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:
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.
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:
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
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.
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
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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
40 | |
39 | |
30 | |
29 | |
29 |