You’re offline. This is a read only version of the page.
Hi All
I have a basic flow that collects information from a Microsoft Form excel sheet and copies the data to a SharePoint site.
The Data transfers fine but every time the flow runs (once a hour) it duplicates the information contained in the sheet.
Hope you can help
Thanks
Rob
Hi @Anonymous ,
Does the Excel table contain fields with unique values? If so, we can use the method provided by @ChristianAbata to set the corresponding column in the SharePoint List to Enforce unique values, so that we could avoid creating duplicate items.
Please take a try and feel free to let us know if you have any questions.
Best Regards,
In sharepoint you need to change to Unique Values.
So when your flow runs again and a row in excel sheet already exist in sharepoint list, the value is'nt copy.
Maeby you are going to receibe an failed flow message, so I recomend to you use try and catch.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
