Unanswered

Mirror Excel Table to Sharepoint List

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Antooooox 38 on at

Like (0)

Report

Nobody? 😃

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Antooooox 38 on at

Like (0)

Report

Thanks! It worked 😃

Was this reply helpful? Yes No
Antooooox 38 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Antooooox 38 on at

Like (0)

Report

Anyone?

Was this reply helpful? Yes No