I have a dataflow that reads from an API, processes the data and then creates records in Dataverse. That works fine when I open the dataflow in the edit mode and then publish. But when I set the flow to refresh automatically without any changes the records don't get created. I reopen in the edit mode and they get created without changing anything...
Any pointers on how to debug the issue?
TIA
Ruchan
The table has a unique key, but this is the way it needs to be. My Flow.
1. Gets the records from dataverse table to find the last processed record.
2. Gets the data external system1 (via API) that is updated after the update date in the last dataverse record.
3. Created records in the dataverse for the new records, (Unique key is used here)
4. Processes and updates a second external system using a second API.
During automatic refreshes the step 3 does not happen. But if I edit the flow and witness the execution the records get created. So if it was a Unique key issue they would not be created during the edit as well..
Is there a detailed log that shows result of every step in a query execution?
Hi @rziya
Can you please check the Table with Any KEY is avialable or not.
If yes then Make Sure the Key is not Unique.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
Fubar
11
Super User 2025 Season 1