Send email remainders from excel data and Update excel column value using Power Automate.
Vložit
- čas přidán 29. 08. 2024
- Send remainder emails to employees from excel and Update excel Column using Power Automate.
Step 1: Create an excel sheet in OneDrive with columns
1)Sno
2) EmpName
3) EmpEmail
4)Subject
5)RemainderDate
6)Status
Step 2: After entering the data select all the data and convert to Table and name the table as Remainders
Step 3: Create a flow with first step as recurrence and give 1 and Monthly .
Step 4: Add a Compose step and get the Todays date in "MM-DD" format . Flow Expression is: formateDateTime(utcNow(),"MM-dd")
Step 4: Now Get all rows from excel list table.
Step 5: iterate all the rows and get the Date value . Surprisingly it will not generate the date format we desired it will show something like 36541 which is not date formate so we need to convert that using a flow expression in compose statement: addDays('1899-12-30', int(item()['Date']), 'dd-MM-yyyy') or addDays('1899-12-30', int(item()['Date']), 'MM-yyyy')
Step 6: Run the flow and check date format.
Step 7: Add if Condition in flow.
Step 8: If Yes send an email
Step 9: Update Excel table column Status with "Yes".
Show Support with Super Thanks Button under video
This helped me w my internship project thank you so much !!
Glad it helped u
Thanks!!!! Just what I needed. Thanks for taking your time to do the video.
Welcome D Hale
thank you so the amazing work flow, i could figure the error and it work successfully
Cool !
Roshni could help me how did you fix the error. I am getting the same error you mentioned above. Thank you.
@@somimickey6734 call us at 9844551679
Very informative and good narration too
So helpful! Thank you!
Super thanks Dude. Very helpful!!!
Welcome @thomas
Thanks a lot! That is exactly what I need, very helpful! but one more question, can i ask how to add the email sent date on the excel file? Once email sent successfully, the emial sent day add to excel table. Thank you!
Take that present day date
this is Awesome!! Thank you for this :)
Welcome Mitch
Add days will only work if the Excel is set to serial number. If it's the ISO format, I just format the date.
Thank you for tutorial, it works as described. How do you display the Reminder Date (formatted as MM-dd-yyyy) into the body of the email?
Use the formula addDays('1899-12-30', int(item()['Date']), 'dd-MM-yyyy') or addDays('1899-12-30', int(item()['Date']), 'MM-yyyy')
thank you this is really helpful
Hi sir,
Thanks for your video. I tried this one and it tested successfully. In order to fine tune this flow, I want to trigger this flow prior to 30 days of the expiry date automatically. So how I can trigger this flow automatically before 30 days of the expiry date?
First find out the days by getting difference from today and date of expiry. So using the days you can achieve your solution
Perfect Thank you for for this,
I have one question Can we merge the date column as we have to send the email to multiple person at the same day, because for my excel (shared file*) Merge is disabled.
Can you pls suggest
Merge yes but with what
Thank you for your explanation , i can't use my personal email for ondrive it has to be business email right?
Yes
Hi, i was lookin for somthing liike this flow and thank you for it, but i get this error in the 2nd compose 'Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.' pls help
Thanks
Step 4 formatDateTime(utcNow(),'MM-dd')
Thanks
I’ve changed the reminder date to a future date on the excel spreadsheet, yet I keep receiving emails
What can I do?
How to do this for 30 days later though?
Hi, when I add the expression addDays I m getting an error. Can someone help please
WhatsApp your error: 9844551679
i tried using this flow but it keeps sending an email eventhough its not todays date in reminderdate
I hope you can reply
check format dates@@MerjelaEvangelista
its still sending me an email i already change the format to MM-DD and MM-YYYY and also used MM-dd-yyyy its same😢
do u have whatspp? +91-9844551679
Ok il whats app you
is it possible to return time (HH:mm) instead of date (MM-dd-yyyy)? thanks
yes. or use substring to extract the part you want