web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : dLvCy7edXvnIPT9BEvP3JD
Power Apps - Microsoft Dataverse
Unanswered

ModifiedOn for the value of a field of a specific record

Like (0) ShareShare
ReportReport
Posted on 8 Feb 2024 10:19:29 by

I have two question regarding updating a record in Dataverse:

 

  1. 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.
  2. 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:
  • Parvez Ghumra Profile Picture
    1,579 Moderator on 08 Feb 2024 at 10:54:02
    Re: ModifiedOn for the value of a field of a specific record

    @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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics