Skip to main content

Notifications

Community site session details

Community site session details

Session Id : dXq7z9idLJHN8aMJDvCuNI
Power Automate - General Discussion
Unanswered

Reminder Post in M Teams Channel for SharePoint Calendar Events

Like (0) ShareShare
ReportReport
Posted on 9 Nov 2021 07:21:20 by 91

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:

substring(item()?['EventDate'],0,10)
utcNow('yyyy-MM-dd')

 

TriggerTriggerBildschirmfoto 2021-11-09 um 08.16.46.png

  • TomTT Profile Picture
    91 on 10 Nov 2021 at 06:41:13
    Re: Reminder Post in M Teams Channel for SharePoint Calendar Events

    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 EachApply to EachCalenderCalender

  • efialttes Profile Picture
    14,756 on 09 Nov 2021 at 07:53:49
    Re: Reminder Post in M Teams Channel for SharePoint Calendar Events

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
Pstork1 Profile Picture

Pstork1 20 Most Valuable Professional

#2
rpersad Profile Picture

rpersad 16

#3
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

Overall leaderboard
Loading started