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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Infinite loop & create...
Power Apps
Unanswered

Infinite loop & creates duplicate records.

(0) ShareShare
ReportReport
Posted on by
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 ?
I have the same question (0)
  • v-bofeng-msft Profile Picture
    on at
    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

  • Verified answer
    Hamish Sheild Profile Picture
    3,005 Most Valuable Professional on at
    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

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard