Unanswered

Saving editor of record when specific column is modified

(0) Share

Report

Posted on by AnttiKai

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.

- 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?

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report

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:

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.

Was this reply helpful? Yes No
AnttiKai 64 on at

Like (0)

Report

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

Was this reply helpful? Yes No