You can check this page.
https://stackoverflow.com/questions/74768396/upserting-rows-with-azure-synapse-from-dynamics-365-using-versionnumber
How to upsert records from Azure Synapse dedicated SQL Pool table Dataverse table in Azure Data Factory?

I want to move data regularly from Synapse SQL pool to dynamics 365 dataverse, Everytime I do that I need to truncate the table in dataverse and run the pipeline in ADF, instead of truncating everytime I found we can do upsert to the dataverse table.
Table in Synapse SQL Pool: Recommendation_All_Progress Table in Dataverse: cr726_progressreporttest Column set as Alternate Key in Dataverse: 'cr726_contactid'
I need to update records based on the above mentioned column.
If the data for that column is in source and in the dataverse, it needs to updated in dataverse, else it needs to inserted as a new row.
I couldn't figure out how can I do this in ADF data flow. Can someone give me the correct method to do this?
If the above provided details is insufficient, please let me know.
I have tried it in data flow, but got this error:
can anyone clarify the error?