
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
・Dataverse table
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
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.
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