cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Administrator
Administrator

Email Lookup Field in Custom Entity

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

Haom

Thank you very much.  That worked.  All I to do now is set up the same approach for the other two fields.  I appreciate your persistence.

Merlin Siefken

View solution in original post

10 REPLIES 10
Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

HI,

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.

www.marksgroup.net/.../

Please mark my answer verified if i were helpful

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

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.  

Merlin

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

Hi Merlin,

There are multiple ways that pull into the custom entity these other fields, 1) Javascript, 2) calculated field, 3) workflow or flow.

Here I will introduce the calculated field, its advantage is that you do not need to code as Javascript, and its setup process is simpler than workflow or flow. Note that the calculated field is not editable on the form.

Create two new fields of calculated for First Name and Last Name.

         

         

Use experience:

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

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

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

Hi Merlin,

1. Is this process reading the first name and the last name from the Project Contact field?

- Yes.

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.

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

Hao,

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.

Merlin

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

Hi Merlin,

Could you provide the error screenshot?

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

Sorry, Past my bedtime and sent the email and shut down.  Saw your reply on my phone.  I got a similar error when I tried the other two fields as well.

Merlin

Highlighted
Administrator
Administrator

Re: Email Lookup Field in Custom Entity

Hi Merlin,

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 √.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,818)