Power Platform Community Forum Thread Details

Hi all,

I have various dataflows that are charging data from an Azure SQL DB to Dataverse tables. There is an alternate key on the Dataverse table that is used to map the lines. I have ticked the box to delete the rows that no longer exist in the query, however, the dataflow is just ignoring these lines and leaving them in the Dataverse table. The documentation says that "Standard V2 dataflows rely on the createdon and modifiedon fields in order to remove rows that don't exist in the dataflows output, from the destination table. If those columns don't exist in the destination table, records aren't deleted." These columns do exist in Dataverse so I don't see this as being the problem.

Can someone help ?

Thanks

Categories:

Microsoft Dataverse with Power Apps