Jun 08 2023 08:11 AM
Hi everyone,
I already have a simple power automate flow for posting recurring messages in a teams channel. Now I want to make the message dependent on the meeting time of the teams channel. Even if I move a recurring meeting item, I want the message to be posted a day before. I have tried a lot of ways with "when an event is updated..." and conditions etc but nothing helped. Perhaps someone has already implemented a workflow for this and can help.
Thanks very much.
Jun 10 2023 05:27 AM
Hi @Malakhassan ,
To create a Power Automate flow that posts a message in a Teams channel based on the meeting time of a recurring Teams channel meeting, you can follow these steps:
1. Start by creating a new flow in Power Automate and choose the trigger "When an event is modified (V3)" from the Microsoft Office 365 Outlook connector.
2. Connect your Office 365 account and select the Team and Channel where you want the message to be posted.
3. In the "Show advanced options" section, set the "Filter Query" field to `IsRecurring eq true` to filter only recurring meetings.
4. Add a "Condition" action to check if the meeting start time is updated. Use the expression `triggerBody()?['ChangeType']` and check if it equals "Start".
5. Within the "If true" branch of the condition, add a "Compose" action and use the expression `addDays(triggerBody()?['Start'], -1)` to subtract one day from the meeting start time. This will give you the date for posting the message.
6. Next, add a "Condition" action to check if the current date is equal to the calculated date for posting the message. Use the expression `formatDateTime(utcNow(), 'yyyy-MM-dd')` and compare it with the formatted date from the "Compose" action.
7. Within the "If true" branch of the second condition, add the action "Post a message (V3)" from the Microsoft Teams connector. Set the Team and Channel, and configure the message content as per your requirements.
8. Save and test your flow. Make sure to modify a recurring meeting item and observe if the message is posted one day before the meeting.
By following these steps, you should be able to create a Power Automate flow that posts a message in a Teams channel based on the meeting time of a recurring Teams channel meeting, even when the meeting is rescheduled.
If I have answered your question, please mark your post as Solved If you like my response, please give it a Like Appreciate your Kudos! Proud to contribute! 🙂 |
Jun 10 2023 10:02 AM
Jun 12 2023 01:31 AM
@Deleted
Hey!
thanks for the detailed response. i'm currently stuck on the first step. As soon as i select "when an event is modified" i only get the option to choose my calender and the following advanced options.
how to continue? Thanks alot!
Best regards, malak