Forum Discussion
SharePoint list showing duplicate data
- Anonymous8 months ago
Hi ZulaikaJanuri,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to amitchandak for prompt and helpful responses.
Apart from the suggested step by amitchandak Please check the fallowing Points,
you should also verify whether the flow is being triggered multiple times (for example, on both file creation and file modification), which can cause the same data to be inserted again. Review the flow structure to ensure the “Create item” action is not placed inside unnecessary loops and that retry settings are not re submitting records when SharePoint responds slowly. Also, confirm that your Excel source does not already contain duplicate rows and consider adding a validation step to check if a record already exists in SharePoint before creating a new item, using a unique key. This will help prevent duplicates even if the flow runs again.Thanks & Regards,
Prasanna Kumar
- Anonymous8 months ago
Hi @ZulaikaJanuri,
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar
Hi ZulaikaJanuri,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to amitchandak for prompt and helpful responses.
Apart from the suggested step by amitchandak Please check the fallowing Points,
you should also verify whether the flow is being triggered multiple times (for example, on both file creation and file modification), which can cause the same data to be inserted again. Review the flow structure to ensure the “Create item” action is not placed inside unnecessary loops and that retry settings are not re submitting records when SharePoint responds slowly. Also, confirm that your Excel source does not already contain duplicate rows and consider adding a validation step to check if a record already exists in SharePoint before creating a new item, using a unique key. This will help prevent duplicates even if the flow runs again.
Thanks & Regards,
Prasanna Kumar