Mirror Excel Table to Sharepoint List

[Antooooox]

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 1	10
Week 2	5
Week 3	12
Week 4	2

[Antooooox]

Nobody? 😃

[v-bofeng-msft · Accepted solution]

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]

Thanks! It worked 😃

[Antooooox]

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?

[Antooooox]

Anyone?