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 new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
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.