Skip to main content

Notifications

Power Automate - Using Flows
Suggested answer

Duplication Errors

(0) ShareShare
ReportReport
Posted on by 21
I have a flow that is triggered by a Microsoft form being completed and it adds a row into an excel table. Two duplicate rows are being added to the table. Can anyone help me find out why? 
 
Thanks 
  • Suggested answer
    Robu1 Profile Picture
    Robu1 918 on at
    Duplication Errors
     
    Thank you for choosing Microsoft Power Platform Community.
     
    Seems like your flow might be triggering twice or there might be an issue with the "Add a row into a table" action.
     
    Here are a few things you can check:
     
    Check Flow Run History: Verify if the flow is being triggered twice. You can do this by checking the run history of your flow. If you see two runs for each form submission, it means the flow is being triggered twice.
     
    Form and Flow Conflict: If your form was created directly from the Excel sheet (using 'Insert' -> 'Form'), the form itself might be adding one row and the flow another. In this case, you can create a new Excel document and set up the form and flow again.
     
    Action Duplication: There might be an issue with the "Add a row into a table" action itself. Try deleting this action and recreating it to see if it resolves the issue.
     
    Excel Sync Issue: Sometimes, Excel might not sync properly until it is opened, causing duplicate submissions. Ensure that your Excel file is properly synced before running the flow.
     
    If this fixes the issue, please mark as resolved to help others in the community to with find it.

    Happy to help

     
    Robu 1
  • Pstork1 Profile Picture
    Pstork1 64,505 on at
    Duplication Errors
    Can you provide some screenshots of the flows actions?  Hard to tell what's wrong without more information.

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard

Featured topics

Restore a deleted flow