Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Mirror Excel Table to ...
Power Automate - Building Flows
Answered

Mirror Excel Table to Sharepoint List

(0) ShareShare
ReportReport
Posted on by Antooooox 38

Hi,

 

I have an Excel document on a Sharepoint page where I display a 8 week look-ahead for some data. Below is an illustration how the table in Excel looks like. 

 

I also have an Sharepoint list, both the Excel table and the Sharepoint list have the two same columns. Title and Amount where Title is week and Amount is amount. I have tried to create a flow for this but for some reason it updates the list with only Week 2 - and the amount on all the rows. I want it to mirror the Excel table so it looks the same in the Sharepoint list. 

 

Since its a 8 week look ahead, the table is updated each week, so at the moment its Week 3 to 10, and next week it will be 4 to 11 and so on. Is this possible to fix? 

 

Week 110
Week 25
Week 312
Week 4

2

  • Antooooox Profile Picture
    Antooooox 38 on at
    Re: Mirror Excel Table to Sharepoint List

    Anyone?

  • Antooooox Profile Picture
    Antooooox 38 on at
    Re: Mirror Excel Table to Sharepoint List

    Hi! It did not work over time it seems. 

     

    When the flow runs it continues to add the same thing over and over again in the Sharepoint-list. Any ideas?Pic1.PNGPic2.PNG

  • Antooooox Profile Picture
    Antooooox 38 on at
    Re: Mirror Excel Table to Sharepoint List

    Thanks! It worked 😃

  • Verified answer
    v-bofeng-msft Profile Picture
    v-bofeng-msft on at
    Re: Mirror Excel Table to Sharepoint List

    Hi @Antooooox :

    Could you tell me:

    • Do you want to sync the data in the SharePoint List to the data in Excel every time? (Need to delete data in SP list that does not exist in Excel table)
    • I there always 8 rows in that excel table?

    If so, you could try:

    Step 1:Create a loop that deletes all records in the SharePoint List.

    Step 2:Create a loop that adds all the records in the Excel table to the SharePoint list in turn.

    If there is any problem, please don't hesitate to let me know.

    Best Regards,

    Bof

  • Antooooox Profile Picture
    Antooooox 38 on at
    Re: Mirror Excel Table to Sharepoint List

    Nobody? 😃

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans