Duplication of records

[Vixen14786]

I have a flow that takes an excel spreadsheet, which is updated automatically by MS Forms to my SharePoint and copies the existing rows to a SharePoint list.  However, when the excel spreadsheet is updated and more rows added to it the Power-auto flow updates the list by pushing all the rows to the list instead of just the new rows added.  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.

Each row has a unique ID.

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

Original File: V1

Updated file: new rows 4 & 5

I only want rows 4 & 5 to be pushed to the list on the re-run.

[v-xiaochen-msft · Accepted solution]

Hi @Vixen14786 ,

Hope you are doing well.

You could check the unique ID in sp list. If the sharepoint list contains the unique ID, then do not create a new item in sp list.f the sharepoint list doesn't contain the unique ID, then patch the new item.

Sample:

Best Regards,

Wearsky

[Vixen14786]

Thank you. Much appreciated.