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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,765)