Microsoft Dynamics 365 | Integration, Dataverse...

Add reason when there is change data in field

(0) Share

Report

Posted on by Community Member

Hi,

I have a requirement where:

There is a Donor entity and if there is change data in a field(Note:to every field on the form),

I need to add reason for this change in a table(new entity) in the Admin Tab(add subgrid of new entity here) of the Donor Record as a free text field.

Each entry in a table also has a date stamp along with slecting value in dropdown that contains the list of fields in Donor.

Any help and how to approach and what is the best way to do regarding the above requirement will be much helpful.

Thank you so much

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sravz,

I think you could create an on save event on your form of Donor entity, and use openForm method (openForm (Client API reference) in model-driven apps - Power Apps | Microsoft Docs) to open table(new entity) form to create records.

And you could prevent save by preventDefault method(preventDefault (Client API reference) in model-driven apps - Power Apps | Microsoft Docs).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Steve,

Thank you for the response. I think its a good start, but I think, I don't need the preventDefault method they just want to reason the change of data in the separate text field.

And also I need to create new Table to record the changes in the Donor, where all the fields of Donor Table must be dropdown in the new Table.

Am I making sense

Please help me.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sravz,

Please correct my understanding: You will create a table which is used to record the changed fields(type is choices) of Donor and the changed reason(type is text).

If so, you could create a form of new table which has these two field and open it when a Donor record is saved.

The preventDefault method is needed because the data is saved by default. You need to save them manually after finishing your business(Open the form of new table and create a record).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Steve,

Yes, I think you are right. But, I need to record the changes against all fields on the form.

I need to have all the the fields as dropdown on the new table.

Is it really achievable, how can I approach.

Thank you for all the help.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sravz,

If your user would change multiple fields at a time, you could create a MultiSelect Option Set(Choices) type field and add each field as an option in the new table.

If only change a field at a time, create a Option Set(Choice) is ok.

Was this reply helpful? Yes No