cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jja
Responsive Resident
Responsive Resident

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
Super User
Super User

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
Super User
Super User

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
Responsive Resident
Responsive Resident

@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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,143)