System fields Createdby and Modified by are not getting updated as logged in user.

(1) Share

Report

Posted on by NV-12080530-0

I created a custom table in Dataverse. This table has the system fields Created by and Modified By, which should get updated as logged in user in CRM when a new record is created by that user.

This is in our DEV environment.

However these fields are always showing my user name, irrespecitve of the user who is creating records.

When I created the table these fields were created automatically and are non-editable lookup fields related to the System user table in Dataverse.

Please help, where I could have gone wrong in creating this table

Thanks

Nalina

All responses (6)

Answers (1)

NV-12080530-0 43 on at

Like (1)

Report

System fields Createdby and Modified by are not getting updated as logged in user.

Thanks Amit,

Yes your suggestion seems to be the right way. Will try that for sure.

Thanks
Verified answer

Amit Katariya007 8,596 Super User 2024 Season 1 on at

Like (2)

Report

System fields Createdby and Modified by are not getting updated as logged in user.

Hello User,

If you have created a workflow and updating this field then you have to set "The user who made changes to the record" setting and not in the owner of the workflow..

Thank you,

Amit katariya
VaHiX 3,119 on at

Like (1)

Report

System fields Createdby and Modified by are not getting updated as logged in user.

** Please don't forget to close up the thread here by Like and verify it as an answer if it was solved **
Suggested answer

Sachin Jadhav 131 on at

Like (0)

Report

System fields Createdby and Modified by are not getting updated as logged in user.

Checkout this thread that might help you with the issue of overriding system fields.

https://community.dynamics.com/forums/thread/details/?threadid=36f44466-95a4-4124-b196-05e413a1746d

Sachin
NV-12080530-0 43 on at

Like (0)

Report

System fields Createdby and Modified by are not getting updated as logged in user.

Hi VaHiX,

Thanks for your response. I forgot to add that there is an Embedded canvas app on CRM page which runs flow to update the table.

I am the flow owner.

Not sure how the Canvas app or the flow can pick up the logged in user credentials and pass on to the dataverse table being updated.

Whatever account I use to run the flow that account will get logged.

From online documentation I got to know that using User().FullName - will give the logged user name in canvas app.

Even then to update the Created by fields (which is readonly) will not be possible.

How to go about this.

Thanks

Nalina
VaHiX 3,119 on at

Like (1)

Report

System fields Createdby and Modified by are not getting updated as logged in user.

Verify the environment settings to ensure that there are no configurations that might be causing this behavior. Sometimes, specific settings in the DEV environment can lead to such issues.

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/user-team-entities

Also please check if there are any plugins or workflows that might be overriding these fields. Sometimes custom logic can inadvertently set these fields to a specific user.

https://debajmecrm.com/override-createdon-modifiedon-createdby-modifiedby-in-dynamics-365-crm-crm-tips-from-the-vault/