cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vixen14786
Regular Visitor

Duplication of records

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

Vixen14786_0-1658910963499.png

 

Updated file: new rows 4 & 5

Vixen14786_1-1658911055877.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

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:

vxiaochenmsft_0-1659077878550.png

vxiaochenmsft_1-1659078776189.png

vxiaochenmsft_2-1659078790602.png

vxiaochenmsft_4-1659078974761.png

vxiaochenmsft_5-1659079001704.png

vxiaochenmsft_6-1659079010444.png

 

Best Regards,

Wearsky

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

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:

vxiaochenmsft_0-1659077878550.png

vxiaochenmsft_1-1659078776189.png

vxiaochenmsft_2-1659078790602.png

vxiaochenmsft_4-1659078974761.png

vxiaochenmsft_5-1659079001704.png

vxiaochenmsft_6-1659079010444.png

 

Best Regards,

Wearsky

Thank you. Much appreciated. 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,700)