cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jja
Resolver I
Resolver I

Model driven app related table field showing on form or view

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?

1 ACCEPTED SOLUTION

Accepted Solutions
rampprakash
Memorable Member
Memorable Member

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

 

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User II
Dual Super User II

@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

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
rampprakash
Memorable Member
Memorable Member

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

 

View solution in original post

@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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,994)