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.
With this flow, I just get the entire table repeated in the sharepoint list for the number of rows in the table itself. I only need the newly added rows.
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.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!