In most cases, organizations have their own unique ID’s to identify records.

As an example, ABC organization uses DBID as their unique internal account code. For each related custom record, they will use DBID as the foreign key to identify the specific account.

Here is the business case : We need to gather Registration Info as a separate record and later link it to the relevant account by matching the DBID of both the records.

In order to link two entities, we have to create a lookup field. In this case, Account entity form should show registration info. Therefore, we need to create the lookup field within Account entity.

Here are the steps:

Dynamics CRM Configuration

1. Go to https://make.powerapps.com > Data > Entities > Account
2. Create new lookup field “Registration Info” and select related entity as the entity you need to link it with. In this case, I am selecting “Registration Info”.

3. Save the entity

4. Since we need to see registration info within account form. Now, let’s add this to account form as a quick view.

5. Go to “Account” > Forms and open the main form.

6. Add component > 1 column section. Then add the new field “Registration Info” to this section.

7. Add > Component > QuickView and select the created lookup field.

You can add this section to any place you like on the form. CRM configuration part is now done. To recap what we have done so far, we have created a lookup field within Account entity so that we can link a custom record and show custom record data on the account form.

Let’s test the form. Go to any account record on CRM and navigate to the new section of the form.

Now, select any record from the lookup field and it will populate the quick view section with relevant data.

Ok, now we know that if we pass the right value to lookup, it will show us all relevant data in the Account form itself.

In my next post, we will discuss how we can auto-populate the lookup value in this field after matching the custom (DBID) field value.

Happy Learning!

Categories: Dynamics 365, Power Automate

Tags: flow, lookup, Relationship