web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Workaround for duplica...
Power Automate
Answered

Workaround for duplicated records created in Dataverse

(0) ShareShare
ReportReport
Posted on by 39

Hi. I created a flow that will synchronize SPO list with Dataverse table.

When a new item is created in SharePoint list, this is trigger for an automatic flow to add a new record with the information of the new item to the Dataverse table.

 

The issue is that each time flow runs, 2 duplicated records are added to the table even though it runs only one time..

The flow writes Dataverse table only one time and doesn't have a loop in it.

 

・Flow result

chickennanban_0-1661405901211.png

・Dataverse table

chickennanban_4-1661411315819.png

 

Also, Item ID(auto numbering by Dataverse) is generated for each. But when I look at run history, it only handles "00001118", and it seems another job with Item ID "00001119" is running in the background.

・Flow run history

chickennanban_3-1661411261715.png

 

This bug only occurs in test environment where I just imported this flow (This doesn't occur in dev environment).

So I believe that this is caused by environmental difference but I'm not sure where to check.

Does any one know why this happens, and how to go fix it or go around it?  Thanks.

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @chickennanban ,

     

    Is it possible that there is another similar Flow running? 

    In addition, maybe you could consider saving the SharePoint List ID to the Dataverse and then before adding the new row to check if this ID already exists in the Dataverse, if so then don't add the new row. 

     

     

    Best Regards, 

    Charlie Choi 

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard