Unanswered

record version for entity

(0) Share

Report

Posted on by Community Power Pla...

Hi,
I want to maintain version of records for CDS entity. multiple rows can exists for one chemical in chemical entity.

suppose, I have one chemical entity and want to store always new records in chemical entity whenever any columns gets update of entity and also want to check in future for which column changes is done in current row. for example in second row I updated chemical type and third row I update review date.

Is it possible to show versioning on entity level for each row?

Please let me know how I can use in canvas app.

Regards,

Lalit Kadam

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,
Have you looked at out-of-the-box auditing on CDS entity? That would give you an audit of old value, new value, date time and user who updates the record. That can be a viable no-code option instead of building that whole capability.
More info on out-of-the-box auditing: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/manage-data
Hope this helps!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Eric,
Thanks for your reply.
I go through the below link. and found auditing is available. have some more query on same.

1. Is this auditing option show different between both row(Previous row and current row) changes? like preview column chemical name was Menthole now in current "Menthole _1" updated.
2. Enable auditing option is available in power app when I click on Entities column name "Enable Auditing".
3. Is any other way to do in power app.
4. As mentioned in below link need to enable auditing option on (organization, entity and attribute level). can you please tell me how we can set on organization and entity level too?

Please give me steps to apply auditing change on entity in power app.

Regards,
Lalit Kadam

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
See below my comments corresponding to your questions. Hope this helps...

If I understand your question correctly, yes that is it. It logs/saves the previous value and the new value every time the field of the entity changes.
Yes, you'll need to enable at the environment/org wide, then you'll need to select the entity within the environment and also you'll need to specify which fields within the entity you wish to audit. This give you granular control so that you don't audit your whole database and potentially increase size and performance impact for nothing.
To enable at environment level: in Power Platform Admin (https://admin.powerplatform.microsoft.com), select your env, then click on "Settings" on the top menu. Expand "Audit and logs" and click on "Audit settings". Make sure "Start Auditing" is checked.
To enable the entity and its fields: At the same place, in "Audit and logs" and click on "Entity and field audit settings". In the new window, click on the entity in the left treeview and make sure "auditing" is checked. For the fields, expand the entity in the treeview, click on "Fields" and open the required fields and make sure "Auditing" is enabled (you can bulk edit the fields).
4. See previous answer #2

Was this reply helpful? Yes No