Skip to main content

Notifications

Community site session details

Community site session details

Session Id : frKVEzyscfCB9tPUl6GnXr
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 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard
Loading started
Loading complete