I would like to have a Flow to update new rows from an online excel to sharepoint. I have lines being added to an online excel file and I would like only these rows to the sharepoint list.
I tried to add an 'Excel get rows' and a 'sharepoint get items' and a condition, with an 'apply to each' for the 'Excel get rows' and a second 'apply to each' for the 'sharepoint get item' and inside the second 'apply to each' a IDexcel not equal to IDsharepoint then do a 'sharepoint create item' action.
This approach seems to be slow and do not create the desired result. I also need the Flow to add as many records on the sharepoint list as the newly added rows.
If I copy all the excel rows everytime I need to update the sharepoint list, how do I avoid generating duplicates?
Is there a better trigger for Excel that is not 'when a file is modified'?
Thanks for the help.
As far as I know there is only one real trigger for Excel, and that is the selected row trigger. I do suspect it would be easy to set up a flow that transfers a selected row from Excel to a SharePoint list. Maybe this is worth considering?
But there is currently no trigger for new rows added to an Excel file.
Thanks for your input. I thought about that too, and seems a good solution. My users however will likely have multiple rows to input so I ma want to consider this option at a later stage. Thanks.
The following simple Flow will do the job in a sense of adding new lines by replacing the old Sharepoint List with a new one based on the actual Excel table. I have another flow downstream of this one to notify users of items being assigned to them and they will receive the same notification over and over again everytime a new table is created.
Any suggestions welcome. Thanks.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!