Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

How to use flow to update Excel Rows from SharePoint Lists

(0) ShareShare
ReportReport
Posted on by 2

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

 

Steelcoyot_1-1611068463966.png

 

Steelcoyot_2-1611068557666.png

 

  • Re: How to use flow to update Excel Rows from SharePoint Lists

    @Steelcoyot ,

     

    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 🙂 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics