You’re offline. This is a read only version of the page.
Announcements
17
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!
Hi @MusicMonkey ,
I am afraid that there is no way to filter duplicated records without unique value in such scenario. System works based on what the logic is and it can't filter itself. If the excel replaces and starts running within a certain logic, the unique field or number should be only way to skip duplication.
If there are multiple fields (over 3 different fields), then, you may add the filter by combining the fields (at least three) to make sure the record is unique but it still not available to make sure the data integrity without unique value.
Best regards,
Jisung Han
Share
Report
All responses (
Answers (
