Flow transfer only new rows from excel table to sharepoint

[Anonymous]

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. 

[ictmusings]

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.

[Anonymous]

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.

[Anonymous]

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. 

[Anonymous]

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.