I have a Powerautomate Flow that posts a message to an MS Teams channel the day before the event starts.
How can I make it so that I can post 15 minutes before the event starts?
Condition is:
Trigger
Hi,
Start time and date come from the calendar see screen.
I have activated the parallelism, unfortunately I do not understand how the syntax of the WDL expression must be structured. Can you help me there?Apply to Each
Calender
@TomTT
Two questions
1.-I believe you are storing event star date &time in your Sharepoint list 'anfangszeit' column, right?
2.- What's the max nr of events do you need to notify daily? Less than 50?
If the answer to both questions is 'Yes' I would:
-configure the 'Apply to each' to be executed in paralel instead of sequentially (which i the default) as explained in the second part of this excelent post: "concurrency control degree of parallelism in power automate"
-Inside the 'Apply to each' calculate the target reminder date and time by means of addMinutes() WDL expression... you can substract 15 minutes, and
-Insert a 'Delay until' action block just before your 'Post a message in chat or channel'
Please note max number of simultaneous iterations in an 'Apply to each' is 50, so if you have more then 50 events to be reported in a same day, you can get undesired effects and need a different approach (probably need to design two flows instead of one)
Hope this helps
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional