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

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Vahid Ghafarpour 12,202 Super User 2025 Season 2 on at

Like (1)

Report

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/

Was this reply helpful? Yes No
NV-12080530-0 84 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Sachin Jadhav 157 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Vahid Ghafarpour 12,202 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
NV-12080530-0 84 on at

Like (1)

Report

Thanks Amit,

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

Thanks

Was this reply helpful? Yes No