creating a Teams-post when an event is due

[Anonymous]

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

[ChristianAbata]

the appointments are in sharepoint calendar right @Anonymous ?

[Anonymous]

exactly. Not a personal or a group calender

[fchopo]

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