I'm looking to update an Excel spread sheet to track schedules posted in Teams Shifts, I've got the process to pull the information from Shifts to a SharePoint lists. I now want to take that data and update an Excel workbook, which will then be used to update a daily action plan. Here is the break down of what I have:
Teams Shifts -> exports daily shift information to a SharePoint lists to include employees name, email address, Shift start Date, Shift Start Time, Shift end date, Shift end time, theme color and notes.
SharePoint -> Needs to update an online Excel work book for each individual
Time added to each row for the dates assigned, notes will be used for the early or late shift
Hi! You can use the Get items SPO action to get the information, then loop through it and use the Excel Online update a row action to get your Excel workbook 🙂