
Announcements
I am trying to take a clunky excel marketing schedule file and have power automate do the following:
1 - Automatically import the data from Excel to Outlook when the file is attached to the Teams Group
2 - Have the calendar event trigger a task in Planner
3 - Have the information entered in the event body transfer to Planner (it can be in the notes)
4 - Have Planner automatically update the start and end dates when modified in Outlook
5 - Have Outlook automatically update the start and end dates when modified in Planner
I am having trouble choosing the right flow options because I need the body of the calendar event to contain information from multiple columns on the excel file and automatically update dates both ways in Planner and Outlook. All of the flows I have seen are only migrating one data column to the Outlook event. The goal is to only have to manipulate one or the other and have things sync. Am I asking too much?