Reminders for SharePoint Calendar Events

[Semirxbih]

Hi all,

I've been dealing with this setup for a while now and I just can't seem to figure out how I can set up a Microsoft flow to email me 30 minutes prior to a Calendar event.

Here is what I'm trying to work around:

• Create event
• Set the 'EventTime' to a specific time
• Grab 'EventTime' and is equal to 30 or 60 minutes.
• Send email reminder when an event is about to happen in 30 or 60 minutes.

Calendar:

Step 1:

- This part works perfectly, it grabs the Calendar event and all the details such as 'EventTime' and all in the

Step 2:

- This part is where I'm stuck on, I'm creating a 'Apply to each' trigger that will use the 'Start Time' and make it equal to 60 minutes (I know it's not the correct formatting in the screenshot posted below - I'll need some assistance).

I can't seem to get this flow in the right direction and I can't seem to find anyone online that has done this before so I can mimic their movements.

All help is appreciated - Thanks in advance.

[v-bacao-msft]

Hi @Semirxbih,

Do you want to use Flow to send email reminders 30 or 60 minutes before the event starts?

I am afraid that if you use the Step 2 of your workaround, you may not be able to achieve your requirements.

The utcNow() function is generally used as an parameter to the addMinutes() function. For more content of expressions, you can refer to the link:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

You could make some changes to your step2. I did a test on my side, it works. Please take a try with the following workaround:

• The previous steps are basically the same. After using Get item to get all the details such as 'Start Time', use Delay util action to send the message 30 minutes before the event starts.

• Still use the addMinutes() function, select Start Time as the first parameter, and the second parameter is a negative number. For example, -30 is to send a reminder 30 minutes in advance.

Expression reference:

addMinutes(body('Get_item')['EventDate'],-1) 

For testing, my second parameter is -1, which is an email reminder one minute before the event starts.

The flow works successfully as below, the message was received one minute before the event started:

Please feel free reply if you need more help.

Best Regards,

Barry

[Semirxbih]

Thanks so much for all your help Barry @v-bacao-msft!

Thanks to your help, I am inching closer to making this happen but I am currently stuck on one step.

It is not letting me choose a 'Dynamic Expression' trigger for the Delay Until condition - Do you know a workaround? Inputting just the text throws an error.

[v-bacao-msft]

Hi @Semirxbih,

Sorry, my reply made you confused. I don't mean to enter Text directly in filed, but input the expression I provided in Expression, and then click Ok, there is a graphical result, as below:

Please feel free reply if you need more help.

Best Regards,

Barry

[GabrielStJohn]

Hello, @Semirxbih!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-bacao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager