Send email remainders from excel data and Update excel column value using Power Automate.

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".

[@onetidbit]

Show Support with Super Thanks Button under video

[@dhale1171]

Thanks!!!! Just what I needed. Thanks for taking your time to do the video.

[@onetidbit]

Welcome D Hale

[@ramlasiyas8842]

Very informative and good narration too

[@meeraa4137]

This helped me w my internship project thank you so much !!

[@onetidbit]

Glad it helped u

[@donpanz88]

So helpful! Thank you!

[@roshnimohd583]

thank you so the amazing work flow, i could figure the error and it work successfully

[@onetidbit]

Cool !

[@somimickey6734]

Roshni could help me how did you fix the error. I am getting the same error you mentioned above. Thank you.

[@onetidbit]

@@somimickey6734 call us at 9844551679

[@jogradinjj5591]

thank you this is really helpful

[@MitchTorres]

this is Awesome!! Thank you for this :)

[@onetidbit]

Welcome Mitch

[@thomasiskandar4596]

Super thanks Dude. Very helpful!!!

[@onetidbit]

Welcome @thomas

[@roshnimohd583]

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

[@ellenkellybrew1487]

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?

[@onetidbit]

Use the formula addDays('1899-12-30', int(item()['Date']), 'dd-MM-yyyy') or addDays('1899-12-30', int(item()['Date']), 'MM-yyyy')

[@ramlasiyas8842]

Thanks

[@pavansharma1643]

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

[@onetidbit]

Merge yes but with what

[@qww760]

Add days will only work if the Excel is set to serial number. If it's the ISO format, I just format the date.

[@Hellokitty-le9gy]

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!

[@onetidbit]

Take that present day date

[@fay5306]

Thank you for your explanation , i can't use my personal email for ondrive it has to be business email right?

[@onetidbit]

Yes

[@ramlasiyas8842]

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?

[@onetidbit]

First find out the days by getting difference from today and date of expiry. So using the days you can achieve your solution

[@donpanz88]

I’ve changed the reminder date to a future date on the excel spreadsheet, yet I keep receiving emails What can I do?

[@nandinips6658]

Hi, when I add the expression addDays I m getting an error. Can someone help please

[@onetidbit]

WhatsApp your error: 9844551679

[@sambrough8236]

How to do this for 30 days later though?

[@hojo7258]

Step 4 formatDateTime(utcNow(),'MM-dd')

[@onetidbit]

Thanks

[@jhoonsilva1]

is it possible to return time (HH:mm) instead of date (MM-dd-yyyy)? thanks

[@onetidbit]

yes. or use substring to extract the part you want

[@MerjelaEvangelista]

i tried using this flow but it keeps sending an email eventhough its not todays date in reminderdate

[@MerjelaEvangelista]

I hope you can reply

[@onetidbit]

check format dates@@MerjelaEvangelista

[@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😢

[@onetidbit]

do u have whatspp? [phone]

[@MerjelaEvangelista]

Ok il whats app you