Based on your description, this is something achievable with Power Automate.
In high-level, your flow design will look like this (you will probably need to make a few changes to adapt it to your use-case):
1 - Triger: When an event is modified (V3), from Outlook connector. Here you will inform the calendar to be monitored, along with eventual filters to the events to be read
2 - "Get a row" or "List rows present in a table", from Excel connector. If you have a primary key (an unique identifier) in your Excel table that is tracked in the Outlook event (e.g.: the event ID, or any unique values that you're using in the event name/description), you can use a "Get a row" action to find the record to be updated. If you don't have an easy match between the event and the unique identifier in the table, you will need to list all records from the Excel table and filter it to identify the record matching the event.
3 - Condition to test if the date in Excel file match the modification in the event (eventually you got a change in the event name or description, not in the date/time).
4 - Update a row, from Excel connector. Under the "True" block of the condition, you will allocate this action and use the unique identifier from your Excel table to determine which record must be updated. Then you just need to dynamically inform the new date/time as input for the respective column.
Let me know if it works for you or if you need any additional help!
✅
If this solved your issue, please mark it as Accepted Answer.
👍
If it helped, feel free to give it a like!
🌐 Explore more Power Platform content on my
Website or on my ▶️
YouTube
💼 Find me on
LinkedIn
Share
Report
All responses (
Answers (
4,267
