I have a custom entity named Completed Project Follow-Ups. The "Project Account" field in the custom entity is related to the Accounts entity. I can lookup the Account Name in Accounts and display it in the Project Account field. The "Project Contact" field in the custom entity is related to the Contacts entity. I can lookup the Contact Full Name in Contacts and display it in the Project Contact field.
I tried creating Lookup fields in the custom entity for the Contact's email, First Name and Last Name. It does not work. The look up displays the contact's full name. How do pull into the custom entity these other fields?
Solved! Go to Solution.
For your requirement you can use create quick view form in Contact Entity and add First Name, Last Name and Email fields on quick view form. Now add this quick view form on your custom entity to show those fields based on your lookup field "Project Contact".
Check below article to setup quick view form.
Partial solution. This does give me the information I need to populate the three fields but it is not a lookup field. I have to take the information form the quickview section and enter the data into the fields. Thanks for your help.
Create two new fields of calculated for First Name and Last Name.
Is this process reading the first name and the last name from the Project Contact field? If so that works for First Name and Last Name but that doesn't get me the Project Contact's email from the Contact entity. This entity "Project Follow-Up" is related to the Account entity via Project Account and to the Contact entity via Project Contact. Haven't been able to figure out how to pull the First Name, Last Name and Email from the related Contact entity record. Thanks, Merlin
1. Is this process reading the first name and the last name from the Project Contact field?
2. Does "Project Contact's Email" refer to the contact's mailbox?
If so, we can create an email field which is calculated and set it as the first name and the last name.
Here we have to go to https://make.powerapps.com/ to create an email field, because the classic customizations do not have field data type "Email".
In the powerapps maker, select the D356 environment, go to Data > Entities, find and open "Project Follow-Up", then add a field.
Select data type to Email, then Add > Calculation. Save.
In the new window, set as follow.
This the error I get. Got similar errors when I tried your suggestion for the First Name and Last Name. It seems to me we are just working in this entity. I need to pull the information from the Contacts entity. Might not be possible.
Thanks for your help.
This error is because the formula is incorrect, we should write the lookup filed name.related entity's field name.
Please check again the two screenshots of the calculated fields in my answer above. The first is how we should write it, and the second is how it looks after clicking √.
Check out the on demand sessions that are available now!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021