How to Send Automated Emails on Specific Dates Using Power Automate and SharePoint | 2022 Tutorial

[@befschef]

I've been working on this for days and finally came across this video which helped me tremendously- it finally worked!! Thank you SO much!

[@michaelalex2322]

Haha, happy to help!

[@1Aston1]

Worked perfectly, your delivery is incredibly clear and to the point. Subbed!

[@michaelalex2322]

@@1Aston1 thank you :)

[@vrajpanchal1556]

michael alex you are "cursing" geniuss,thanks man ,u make it short and informative , much appreciate ya

[@michaelalex2322]

I appreciate that!

[@MegaTrickles]

Hi Michael, This is super helpful. I wondered if it’s possible to do this for one item in a list rather than the whole list? And if so how I would do that?

[@TheSomeRandomPerson]

Perfection -Thank you! I'm Aussie so I used 'AUS Eastern Standard Time' but everything else worked great!! Thanks again!!

[@michaelalex2322]

Glad it helped!

[@deepermindfulness]

Thank you. Very much appreciated this one. We'll done. Been on my to do list. You make it look too easy. It would really help to see how you use a distribution list for the recipients. Something else, as I work in other systems and the recipients are in one spreadsheet and the dates are in another spreadsheet held in a Sharepoint folder, it would be great to see an example of pointing the flow to look for the two spreadsheets in a folder. Thank you. All the best.

[@michaelalex2322]

Thank you. You could do that with a Flow, but I think it would be a lot easier to combine the spreadsheets and go from there.

[@deepermindfulness]

Thank you Michael. We do lots of training courses and just an extract from the registration system to the folder would be perfect. In the spreadsheet you would pick up course type and select that folder with the email templates for that course type.

[@christinawhite8941]

Wish I would have found this video two weeks ago. Worked perfectly! Thank you!

[@michaelalex2322]

Glad it helped!

[@Matiely617]

So helpful!! Thank you thank you 🙌🏼finally one that worked 😂

[@sarans3220]

Wonderful stuff

[@AmberLopez-g4o]

Thank you so much for this video. It finally helped me resolve an issue with my flow. Very easy to follow. Thanks again.

[@michaelalex2322]

You're welcome!

[@spitsparrow]

Been struggling with this forever. Making scheduled flows based on calculated columns just wont work. I will try your way. Is there an updated version of this. Would love to see it. I have a calculated column that is just a date dd/mm/yyyy and i want to send reminders 20 days before that calculated date. I havent got it to work. The flow actually tried to run and has no sent me over 1000 emails and then 1000 failed reminder emails . A nightmare

[@bophaphang3170]

Hi Michael, I have a question regarading on this, I want to send a reminder email and it will take the date form the sharepoint list, could you please advise what is the connector that I need to use on that flow? Thank you so much!

[@charizard_baller69]

Hey bro, I need to be able to send an email for different date fields. Pretty much they are reminders based on a list of dates. Any ideas on how to incorporate to this beauty?

[@Aaronsworld-dg8nv]

Hi there, do you have any videos for how to create email reminders for Product Referral?

[@buppal7872]

awesome video, what if there are two events on the same date? how to send two separate emails?

[@TreyJ34]

Love the video and this is EXACTLY what I want to do. I've set up my Sharepoint List and have it all set up. I followed all your steps but I get an operation error in the Get Items step saying "Action 'Get items' does not have a limiting folder parameter, filter query or top parameter." Can you please help

[@TreyJ34]

Fixed: So this error happens when the date of the list is empty. It will still run and correctly send you the emails for dates listed but once you put all the dates in then it will fix this. This is perfect. Thank you for such a clear and great video. You have earned a subscriber

[@sohadaneen7639]

Hi Alex, Nice Vedio, I have an requirement like , I have sent Initial mail and after needs to send update on top of it initial mail, how can we achieve this? My source data is Share point excel sheet where I have values like Initial ,Update, Skip, Resolution where ever I changed the status I need to send an email on top of it Initial mail only.

[@priyankab6488]

Thanks for sharing video this video is realy helpful and implemented successfully...we can also use without time zone function only using formateDateTime function...Thanks Sir..

[@michaelalex2322]

That works too!

[@cvkealey]

Nice job! For the time zone conversion, there's actually a "convertFromUtc" expression in Power Automate that could save you a few characters there. Also, you could use an oData filter in the Get items expression to eliminate the need for the condition. Filtering dates can be a little tricky, and I don't think you can filter on a calculated column, so you'd need to rethink that part. I learned a LOT about this sort of process by dissecting a "Send a reminder" flow on a SharePoint list.

[@michaelalex2322]

Thanks for the info. I'll have to check it out!

[@chrisw2445]

I am really green when it comes to Power Automate, but is there a way to send emails based upon a calculated column? I am trying to send a New Hire Evaluation to the Manager of the New hire every 30 days within their first 6 months. I enter the start date and the other dates are calculated. Does that make sense?

[@cvkealey]

@@chrisw2445 You actually could do this without any calculated columns, just the Start date. Basically, you'd have a scheduled flow that runs once a day and checks for any entries where start date is [current-date]-180 days, [current-date]-150 days, etc.

[@chrisw2445]

@@cvkealey Sorry to be a pain but what would that look like? I set up the Recurrence for daily but what would be the next action item or trigger that I would need to establish?

[@ck6226]

@Michael Alex, Thanks for sharing the video this video is beneficial and implemented successfully. can you guide me on how to create such a multiple-country holiday notification flow that checks the date of the holiday with the country, whichever country has a holiday, a notification should be sent to an email, if there is a holiday simultaneously in multiple countries, I only want one email notification that includes all the necessary details for both country's holiday."

[@qiushengzhang7784]

Thanks for your help! I still don't understand why we need to convert Time?

[@michaelalex2322]

The time by default is in Coordinated Universal Time (UTC). You need to change it to your timezone

[@MaribelTapia-i2w]

Such a helpful video! For some reason when I start the Send and email function it creates an "Apply to each" condition within Yes. Do you know why that might be?

[@michaelalex2322]

Do you have multiple people in your person field. Since that is an array it would put it into an "Apply to each" since each there are multiple people.

[@RileyStephens-z7l]

Hi Michael, how can I see/change what time the email will be sent?

[@michaelalex2322]

Should be in the first Recurrence action and click on 'Advanced Options'

[@dandrem.4074]

Wait, did the Recurrence just add automatically?

[@Sinisha4]

At the end of flow I get error message: ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

[@julianpaullopez3801]

This is incredible, great video for sure, one doubts: where did you have that lists? it was inside of your sharepoint, but was it like a kind of Excel or something? thank you in advance :D

[@michaelalex2322]

It's a SharePoint List

[@miladmirzaei1762]

My automate it is not working, and it seem the system does not consider the calculate column as correct date, could you help me with this, because when I select the normal date my automate send an email but when I choose calculate column the system does not send an email.

[@thomasehmayer9113]

Thanks for the video! I've noticed that when I add another item to my Sharepoint list, the flow doesn't find the new item. Any ideas on how to fix this?

[@michaelalex2322]

Eh could be a few reasons. How many items are in your SharePoint List?

[@thomasehmayer9113]

@@michaelalex2322 Figured it out! I had to increase the top count in the get items action.

[@michaelalex2322]

Yeah you can do that or increase the Pagination limit in the action settings

[@jessapucot9062]

does this work with excel?

[@MultiChris7777]

I am getting an error: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'

[@michaelalex2322]

You have a blank date in your list somewhere. Either fill in those dates or you need to adjust the formula too account for blank dates

[@AcucsThamarai]

Hi how can i send the users to update the status on after 10 days of completing the exam, could u pls help me on this

[@michaelalex2322]

Log the completed exam date in a Date Field in SharePoint. The make a daily scheduled Flow to go through each SharePoint item. Use a compose to addDays() to the completed date. If today's date is greater than the completed date + 10, then send an email.

[@vinibellapertiwi5624]

in formatdatetime i have error 'Apply to each' please help

[@vinibellapertiwi5624]

'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'Condition' are not defined in the template

[@meertingles4015]

Hello .. I have followed the exact steps .. and the output of condition is always false even when it is true? Please help me solve this

[@meertingles4015]

I figured out the error .. the output of get items of the calculated item is wrong .. dunno how to fix this

[@michaelalex2322]

What's the error message?

[@dilpreetkhangoora7575]

@@michaelalex2322I get the same error. It’s ‘ActionBranchingConditionNotSatisfied. The execution of template action ‘Send_an_email_(V2)’ skipped: the branching condition for this action is not satisfied.’ Could you help please

[@TimWhiteHomes]

@@michaelalex2322 First off, great video! Thank you! I am having the same issue as the post above, always getting a false value when it should read true. Flow is running fine, but never tripping the email action on the days it should. My condition expression looks like so: formatDateTime(items('Apply_to_each')?['OData__x0031_stARDueReminder'],'MM-dd-yyyy') Any idea why it is always coming up false?

[@diogopereira9221]

@@michaelalex2322 Hello! i dont have an error message. it's just the dates are equal and they return as false...

[@PriyankushSingh-j3u]

Please make the video for excel sheet too

[@michaelalex2322]

Not sure if it is possible with an Excel sheet. Don't believe there is an action with Excel for that. I'd have to look into that.

[@Jean-Paul1001]

I followed step by step and didn't work, got on the condition the expression result false

[@diogopereira9221]

I am facing the same problem. All values are returning false. But they are not. I tried something similar but without the calculated date. And it works… helllppp 😅