Unanswered

Infinite loop & creates duplicate records.

(0) Share

Report

Posted on by Community Power Pla...

I have a business scenario wherein SQL Server on-premise table & Dataverse table to be in sync all the time.For this I have created automated flow from SQL Server -> Dataverse table & another flow from Dataverse table -> SQL server.

But on testing it,this goes in to infinite loop & creates duplicate records.

Can you help on how to achieve it ?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Re: Infinite loop & creates duplicate records.

Hi @Anonymous :

Can you tell me how your flow is set up? (A screenshot is best)

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report

Re: Infinite loop & creates duplicate records.

Hi @Anonymous

For your scenario I would look at defining an alternate key on your table in Dataverse and set that to a unique identifier from the SQL table. The in your flow, add logic to check whether the alternate key value already exists in Dataverse before creating a new record, otherwise update the existing record.

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/define-alternate-keys-reference-records

Was this reply helpful? Yes No