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 how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.