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?
Solved! Go to 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
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
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
@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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
22 | |
5 | |
5 | |
3 | |
3 |
User | Count |
---|---|
23 | |
8 | |
8 | |
6 | |
4 |