I am trying display my SharePoint list in an excel spreadsheet for reporting to a client on various items.
The SharePoint list is being auto-populated (new items added) by a flow when a form gets submitted.
the list is also being updated manually when a status is changed.
I have a spreadsheet (table1) with data from the SharePoint list as a start. And I have followed some instructions to complete a flow, but it is failing.
Can anybody help? Here are some screen shots of the flow for a more complete illustration.
screen shots
Hi @kirstenk2020,
When an item updated or created, it just one item comes, if you update an existing item in the list or create a new item, it just will run once.
If it is updated, according to the Key value ID is enough:
If you add the Apply to each surround the Add a row and Update row action, it will run many times, the number is the whole rows in Table 1 of the CIT_issues_report.xlsx:
So, what you want is to add multiple repeat rows when an item created? Not really, right? So, please just have a test, thank you.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am rather confused, if I don't have an apply, how would the spreadsheet update with the changes?
Hi @kirstenk2020,
Yes, I know, I mean just delete the Apply to each action 2, or delete the two Apply to each all. The Add a row into a table action and update a row action should be kept.
The reason for the Flow will fail maybe caused by apply to each 2 action.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I thought that I needed two branches, as if there is a new row, I want to create another SP item, and / or if there is a change to any of the SP items, I want the change to be reflected in the excel table.
Hi @kirstenk2020,
You could just delete the Apply to each 2.
In fact, I don't think we need either Apply to each. Because of the newly created item always one.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response @v-litu-msft, do you mean that I should remove only the Apply to each 2 under the branch for If No?
Do I leave the other one?
Hi @kirstenk2020,
Thanks for your screenshot, please try to remove the two Apply to each action in the two branches of condition action:
It's unnecessary to add it cause you just want to update one row in the Excel file.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
David_MA
292
Super User 2025 Season 1
Michael E. Gernaey
259
Super User 2025 Season 1
stampcoin
212