Model driven app related table field showing on form or view

[jja]

Hi

I am pretty new to dataverse and model driven apps.

How do i achieve this scenario:

I have Customers table with Customercode as a primary column and a Customer name as a Text

I have a Projects table with a ProjectNumber as primary column and a Customer column that is a lookup to Customers table column.

Lookup field returns me a Customercode which i understand that dataverse works like this - it returns only primary key values

How do i set it up to return to the form when i enter a customercode so the customer name gets also returned and written into separate field so it is readable for users in form and in view?

[Mira_Ghaly]

@jja

The best way to achieve this is to use the form component control, please check the article below on how you can achieve this. 

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/form-component-control

[rampprakash · Accepted solution]

Hello @jja,

There are multiple ways you can achieve this

1. Quick View

Go to make.powerapps.com -->Expand DataVerse --> click tables then click on Parent Table(Customer) --> then click View --> click New and Select Quick View Form --> add Customer Name into the form --> Save and Publish

Then Go to Tables again and Select Child (Project) then Click On Forms Open Main Form --> Add a Quick View --> then select select the Look for as CUSTOMER and select the quick form in the select Selection. 

Click Save and Publish. That's it 🙂

Please find my Youtube channel below for Series of DataVerse and Subscribe the same.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

[jja]

@Mira_Ghaly  does this method will return also this scenario:

I create new project in projects form enter project name, then lookup for customer and when i select needed customer on other form field it can automaticaly populate related data from customers table in some field like customer name, adress, responsable person etc?