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
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!
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.