Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Saving editor of record when specific column is modified

(0) ShareShare
ReportReport
Posted on by 64

Hi all!

I'm trying to build something that will save the latest editor (no. 1 in images) and the edit time (no.2 in images) for a field that users modify in a model driven app based on dataverse. Kind of a change log that only saves the latest edit. I got the flow working to pull the current time, but face trouble fetching the user that modified the field.

AnttiKai_2-1651486911026.png


- is it valid to use the /systemuser/ [Modified By (Value)] --> pulling in the latest editor of row

- Or is there better ways to save the user that just did changes to that field?

AnttiKai_0-1651486684040.png


Current version give error:
Creating Entity with an invalid parent. Entity: Task, ReferencingAttribute:cr149_lisatietojaviimeisinmuokkaaja

  • AnttiKai Profile Picture
    64 on at
    Re: Saving editor of record when specific column is modified

    Hey @v-jefferni and thanks for the reply and proposal, I went through the links but no straigth solution. My client de-prioritized this after we got the date-time working, and I only had a moment to get back to the issue now.

    - that "Henkilöt" is the default "contact" column with name changed, we have names and emails there mostly and a few added columns
    - the solution you provided gives the same error as before, Creating Entity with an invalid parent. Entity: Task, ReferencingAttribute:cr149_lisatietojaviimeisinmuokkaaja

    The entity where I try to save the information is a modified version of the default "Task" entity and I came across this post and wondering if that could be the issue. The possibility to enable those rows under Communication & Collaboration are greyed out for the entity.
    https://kb.xpertdoc.com/display/trouble/Error-+Creating+Entity+with+an+invalid+parent.+Entity%3A+Email

    I know that it would be better to remake the whole thing with a new table (instead of using a modified version of the default task-table). Still, there's a bunch of legacy stuff that would need ot be fixed so it's not been done so far..

  • Verified answer
    v-jefferni Profile Picture
    on at
    Re: Saving editor of record when specific column is modified

    Hi @AnttiKai ,

     

    Could you please clarify what type is that field? I assume it is a LookUp column, so like mentioned in below thread

    https://powerusers.microsoft.com/t5/Building-Flows/How-do-I-include-Dataverse-lookup-records-in-a-new-Dataverse/td-p/1225662

    https://linnzawwin.blogspot.com/2019/11/power-automate-how-to-set-lookup-field.html

    the value for the User LookUp column should be:

    vjefferni_0-1651648228034.png

     

    But there is a question: I can see the table that this column Look to is "Henkilöt" but it seems not like User table, you need to double check the related table for this column.

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

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

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1