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?
