web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Pre-populate look-up fields from a parent entity

(0) ShareShare
ReportReport
Posted on by

Hi there,

We're looking at how to manage communications with supporters. Our supplier's development does not meet our GDPR requirements and we've hit a stalemate.

Our structure is that we have a parent record "Preference Declaration" which records the source of the supporter's communication update. It has a customer ID look-up field which is prepopulated with the customer when created from the customer entity.

The Preference Declaration then has a 1:many Consent and Subscription entities hanging off it as child entities; these entities also have a direct link to the Customer record also, but cannot exist without a Declaration record.

Upon clicking on Add new Consent or Add new Subscription, it obviously opens a new form which has fields from the parent Declaration completed (name of Declaration, Source and Source Campaign), but it doesn't prepopulate the Customer the fields.

pastedimage1604494628907v3.pngpastedimage1604494598162v2.png

Is there a way to build a Flow or something which pulls the Customer data from the Declaration into the Consent and Subscription records, without requiring users to enter it again?

Thanks!

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Rachel,

    As you mentioned above, customer entity is Account or Contact or both them (customer data type).

    The Preference Declaration and Customer is N:1 relationship and Preference Declaration and Consent/ Subscription is 1:N relationship.

    What you want is that populate child record lookup fields with the value of parent record, right?

    Here are steps. (In my example, I test with customer data type)

    1.Go Power Automate(https://us.flow.microsoft.com/en-us/ ) to create an Automated flow.

    2.Add ‘When a record is created’ as trigger.

    pastedimage1604554961013v1.png

    3.Add ‘Get Record’ action.

     pastedimage1604555013148v2.png

    4.Add ‘condition’ action.

     pastedimage1604555057494v3.png

    (1) In ‘Yes’ branch, add ‘Update a record’ action with accounts type.

     pastedimage1604555171666v4.png

    (2) In ‘No’ branch, add ‘Update a record’ action with contacts type.

     pastedimage1604555298743v5.png

    Note: if your customer is just account or contact, you don’t need add condition, add 'update a record' action directly.

    5.The overview of the flow:

     pastedimage1604555484046v6.png

    6.Test.

    (1)Clicking on Add new Consent, it will open new form.

     pastedimage1604555490381v7.png

    (2) Clicking Save button and wait several minutes to refresh page, the field will be filled automatically.

    pastedimage1604555568877v8.png

    For the Subscription, you refer aboved same steps to create the flow.

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Partner,

    Has the problem been solved? Any updates?

    Please click Yes under "Did this answer your question?" to close this thread.

    pastedimage1604890621366v1.png

    Thanks. 

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Daniyal Khaleel Profile Picture

Daniyal Khaleel 27 Most Valuable Professional

#2
11manish Profile Picture

11manish 18 Super User 2026 Season 2

#3
Syed Aqib Raza Profile Picture

Syed Aqib Raza 17

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans