VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
Automate Emailing Excel Task Reminders with ZERO Coding! - My Online Training Hub

Automate Emailing Excel Task Reminders with ZERO Coding! - My Online Training Hub

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
Automate Emailing Excel Task Reminders with ZERO Coding! - My Online Training Hub With Power Automate's point and click interface anyone can automate repetitive tasks. In this video we look at how to automate emailing reminders based on an Excel task list. Get the written step by step instructions here: https://www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate Link for the list of Time Zone names: https://bit.ly/3HdmIgF 0:47 Data Format Requirements 1:18 Power Automate Excel Add-in 2:03 Opening Power Automate Online 2:19 Create Scheduled Cloud Flow 2:50 Get Data From Excel 3:39 Filter Data in Excel Table 5:45 Exctract List of Emails from Table 6:22 Get a Distinct List of Emails 7:00 Exctract Data for the Email 8:07 Create HTML table 9:35 Create Email 11:05 Recap Steps 11:34 Test Flow 11:58 Inspect Steps
Date: 2022-04-08

Comments and reviews: 10


Excellent tutorial! I would be curious though if there is a way for it to only send the email for a task once (i.e. such as a week before the due date, instead of every day leading up to it)? Also, what happens if you don't remove tasks from the list? Does it only pull from tasks that are after the current date?
reply

So many cool use cases, thank you! For mine, I need to to show any data added in the last 7 days in the output tables say, not just due on todays date. How might I edit the Filter Query expression in the List Rows step? Any tips appreciated! edit: Similar to Gordon Price :)
reply

How come if I try to add Dynamic Content to the -send email- it creates an aply to each 2? This seems to be creating an error. Can anyone help on how to fix this? Is there an expression I can use to pull in data fields from the original table?
reply

Great tutorial Mynda. If I need to capture all rows/records that fall within say today and 60 days later, how would I best build in the filter?
Tried to replace the -eq- with a -le- in the list filter query, but it didn't like it.

reply

That may not be coding, but that is quite a bit of formula usage that the average person would not even know about. Thank you for being so skilled, but you should probably share how you know these formulas and what they mean.
reply

Love your stuff but would argue the zero code description. You need to know some fairly complex syntax to get this working and imho, if there-s syntax involved then it-s code. Low code but code nonetheless and therefore not zero.
reply

Excellent tutorial Mynda, thanks for sharing. I couldn't add the filter for the second action as I failed to find the proper format for Canada EST. Otherwise, it worked fine.
reply

Excellent tutorial. Excellent explanation. The flow can be easily adapted (with the great explanations of Mynda), to different flows. Thanks for sharing Mynda.
reply

Thank you for sharing, this is very useful. I am trying to do some automation to update a few files and this will help a lot. Thank you again.
reply

Extremely well done, i picked up the truncated link and it works perfectly...as always..being automated is showing me i need an assistant -
reply
Add a review, comment






Other channel videos