Forum Discussion

ZulaikaJanuri's avatar
ZulaikaJanuri
Regular Visitor
8 months ago
Solved

SharePoint list showing duplicate data

Hi All,   I’m experiencing a problem where, after uploading data from Excel to a SharePoint list using Power Automate, the data appears duplicated.  Upon checking the run history all number of line...
  • Anonymous's avatar
    Anonymous
    8 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

  • Anonymous's avatar
    Anonymous
    8 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