Power Platform Community Forum Thread Details

Preventing duplicate entries in a SharePoint list

I have a flow that takes an excel spreadsheet and copies the existing rows to a SharePoint list. However, the excel spreadsheet will need to be updated a few days later and more rows will be added to it. Uploading the same spreadsheet (with new entries added) to the flow results in the duplication of previous entries that were uploaded from the first run.

Is there a way to re-upload the same file without duplicating records?

I do not think that enforcing unique values will work since I am using a flow to get the rows from an excel sheet and put them into a SharePoint list. It is my understanding that enforcing unique values is done on the SharePoint side and would cause my flow to break if I tried adding a record that was previously added to the list and labeled as a unique value.

Example:

Version 1.0

This is the original excel file (Ver. 1.0)

Fruit	Quantity
Apples	3
Pears	4

Version 1.1

Fruit	Quantity
Apples	3
Pears	4
Oranges	2

This would be the updated excel file (Ver. 1.1). I would like to be able to re-upload the newly updated excel file into the flow, but omit the entries of "Apples" and "Pears" and only add "Oranges". Creating a new excel spreadsheet for the new entries/rows is not ideal, and we would like to be able to use the original spreadsheet (with new entries added to the table, Ver. 1.1). All entries will be located within the same excel table (only one table in the excel file).

Is this possible? I have tried using a condition but that doesn't seem to be working at the moment.

I can also upload screenshots of my current flow if that will bring some clarity to the issue!

The flow currently works as expected, other than the duplication of entries.

Thank you for any and all help!

Quick Links

Leaderboard > Power Automate