Lookup Columns Changes not Audited in Dataverse Audit History

(1) Share

Report

Posted on by Salem

187

Not sure if this is a limitation or I am missing something here.

I have Audit history working fine for all field types for many tables, but not for any lookup column.

I have auditing enabled for both tables (in relation to the lookup) and when changes are made, all are audited with the exception of lookup columns (all of them).

All help is appreciated.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (5)

Report

Hello @Salem,

Please check weather you have enabled Auditing in the Field level.

Navigate to make.powerapps.com --> Click on settings at the Top --> Click Advance settings --> Click Customization --> Click Customize the system --> Expand Entities --> Expand Which entity you need to enable auditing for lookup field --> Click Lookup Field --> Open it and Make the auditing Enable--> Then Save and Close then Publish it

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Salem 187 on at

Like (1)

Report

@rampprakash that works thanks a lot.
Do I have to do this manually for every lookup field, is there a way to make them "audit-able" by default (even when creating tables) or batch update this property for all lookups?

Thanks again,

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (2)

Report

Hello @Salem,

Unfortunately, there is no other way, while creating a field itself we need to set this to avoid this type of issues.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (2)

Report

You can edit multiple fields in the referenced editor. Select all lookup fields of which you want Auditing Enabled -> Edit -> Edit Multiple Fields -> Tick Audting Enabled -> Save -> Publish

Was this reply helpful? Yes No