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

[@onetidbit]

Show Support with Super Thanks Button under video

[@meeraa4137]

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

[@onetidbit]

Glad it helped u

[@ramlasiyas8842]

Very informative and good narration too

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

[@dhale1171]

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

[@onetidbit]

Welcome D Hale

[@thomasiskandar4596]

Super thanks Dude. Very helpful!!!

[@onetidbit]

Welcome @thomas

[@donpanz88]

So helpful! Thank you!

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

[@MitchTorres]

this is Awesome!! Thank you for this :)

[@onetidbit]

Welcome Mitch

[@MyRockMyFortress]

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

[@jogradinjj5591]

thank you this is really helpful

[@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')

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

[@donpanz88]

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

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

[@ramlasiyas8842]

Thanks

[@sambrough8236]

How to do this for 30 days later though?

[@hojo7258]

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

[@onetidbit]

Thanks

[@nandinips6658]

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

[@onetidbit]

WhatsApp your error: 9844551679

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

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