Hello,
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.
Hello,
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.
Hello @ictmusings,
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.
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!
User | Count |
---|---|
40 | |
36 | |
34 | |
32 | |
27 |
User | Count |
---|---|
40 | |
37 | |
33 | |
25 | |
22 |