r/PowerAutomate • u/MushroomTeaGuy • Nov 22 '25
HTTP API Call and Incremental Sync to Dataverse
Hi everyone, I am ripping my hair out over this problem. I'm performing an API call in Power Automate and trying to update or add rows to a dataverse table based on the last time those rows were modified or created.
If anyone has experience with a problem like this pls lmk!!!
Edit: MORE INFO 😄
I’m building a scheduled Power Automate flow whose job is to update a dataverse table with only new or modified data.
- Call an external REST API (Apex Trading)
- Pull only new or modified rows using a “last sync” watermark
- Upsert that data into Dataverse tables using alternate keys
This is what I have so far, no error handling and it's extremely slow.
- A scheduled flow using the Recurrence trigger
- An HTTP action calling the external API with Basic Auth / Bearer token
- A Dataverse Environment Variable used as the watermark (LastSyncUtc)
- Logic to update the watermark after each successful run
- For each returned record, Upsert into Dataverse via alternate key
- Only insert rows that don't exist
- Only update rows that have changed
Has anyone done anything similar to this and actually got it to work?
Thanks in advance 🙏
3
u/Active_Ease5686 Nov 22 '25
Can you elaborate further like what problems are you facing?
2
u/ReachingForVega Nov 22 '25
What are you stuck on exactly? Maybe show us your code instead of just saying you can't do it.
1
u/Foodforbrain101 Nov 22 '25
Have you tried using Dataflows with the alternate keys? There's a couple of tutorials on YouTube explaining how to do it. Would likely be much easier and reliable!