Power Platform Community Forum Thread Details

I have two question regarding updating a record in Dataverse:

how can i check in dataverse when the value of a field of a specific record was last modified? I managed to find when the record was last modified, but not each field.
Does the dataverse action 'Update a row' in Power Automate only update if the given value in the PA action is different than the value in dataverse? Or does it update all the fields with given values in the PA action no matter what the current value in dataverse is?

Categories:

@JurSap82

1. You can either rely on the Out of the Box auditing functionality as described here. Alternatively, if you require more structure and control around the audit information, then you will need to create a custom date/time column associated with each other column, and then build a workflow/cloud flow/plugin to set the value of this when the corresponding column value is set/updated on a record. Depending on the size of the target table in terms of number of columns, this maybe a lot of work and consume a lot of resources. So this is not the recommended option

2. My understanding is that all 'Update' operations in the platform will write all the specified columns in the Update operation, regardless of the current values of columns at runtime. I believe this applies to the Power Automate 'Update a Row' action in the Dataverse connector too. But I believe the auditing feature will not always store or show the 'noisy' updates of column values 'changing' to the same value again.