Share
Report
36I am new to Power Automate and we are working on creating a flow to sync dataverse data (Contact table) into a custom Azure SQL table. I have been able to get both an insert and an update to work, but now want to combine them into one process. I set up the flow by doing a get all rows on both the dataverse table and the sql table, then do a condition to check if the ID is equal to the ID of each table (alternate key in Contact and Primary Key in Azure SQL), if Yes, then do an update, if No, then add a new row.
I have run the job and the data is inserting/updating as expected, but I am getting errors after the condition. It looks like it is just passing all values through each condition.
Is there a better approach for trying to perform an Upsert from dataverse to Azure SQL?
All responses (
Answers (
