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!