Hi all, my plan is to automatically create a post in a Teams-Channel when an appointment of an additional calender (created in the Teams´ Sharepoint) is due.
Created this calendar only for showing upcoming (FYI-) events for my team
Any idea? THX a lot in advance
the appointments are in sharepoint calendar right @Anonymous ?
Proud to be a Flownaut!
exactly. Not a personal or a group calender
Hello @Anonymous
Those events are created in the "Events" list in the SharePoint site. Therefore, you could do something like this:
1) Each day
2) Get the events where the StartTime value is less or equal than a day before the current date. Be careful with the single quote before the addDays expression.
3) If there is any item (length(body('Get_items')?['value'])>0)
4) Post a message in teams.
You should take into account your time zone and do a previous conversion of the current time (utcNow) if necessary (use the conver time zone action, for example).
Hope it helps!
Ferran
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
64 | |
23 | |
16 | |
15 | |
11 |
User | Count |
---|---|
121 | |
36 | |
32 | |
28 | |
26 |