Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Add reason when there ...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Add reason when there is change data in field

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add reason when there is change data in field

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add reason when there is change data in field

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add reason when there is change data in field

    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).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add reason when there is change data in field

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add reason when there is change data in field

    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans