Answered

Formula Lookup

(2) Share

Report

Posted on by jda2005py

I'm trying to do what I think is quite simple but have never done this before and got stuck.

I have two tables the first one is Contact List (Full Name, Email, First Name, Last Name) and second is projects list. On the second one I have the project manager name and I want to create in this table another column to lookup the Contact list and give me back the email address for the project manager listed. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hey. Are you able to get the project manager's email address by using Power Fx similar to the following, where you can replace locMyProject with the project of interest and change other field names are required?:

locMyProject.'Project Manager'.'Primary Email'

Was this reply helpful? Yes No
jda2005py 21 on at

Like (2)

Report
Copy link

Link copied!

@KeithAtherton I don't quite get your answer, but I can't use the project name as it keeps changing so I need to use project manager name.

Was this reply helpful? Yes No
Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

My code snippet was a way of obtaining the project manager's email address using Power Fx in a canvas Power App text label as this value can be looked-up.

However, if you need a table column to explicitly show the project manager's email address then create a new column with the following properties:

- Data type: Single line of text

- Format: Email

- Behavior: Calculated

Then set the calculated field action to Set <value> to projectmanager.internalemailaddress (or similar).

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,866 Moderator on at

Like (1)

Report
Copy link

Link copied!

I presume you are using SharePoint. You should create the Contact list as a lookup column type in the Projects list in SharePoint

When you create your Power Apps screens the tables are linked so you will probably select the project manager using a combo box and you can access the email using Projects.Contact.Email

Was this reply helpful? Yes No
jda2005py 21 on at

Like (1)

Report
Copy link

Link copied!

ronaldwalcott I'm not using SharePoint, I'm using Dataverse. Any ideas how can I do that?

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,866 Moderator on at

Like (1)

Report
Copy link

Link copied!

One project manager can have many projects

Use the relationships option. under schema (e.g. of what it would look like below) to create the relationship between contacts and projects. You should then be able to use the .notation to get whatever values you need.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Do any of these suggestions answer your question? If so can you please mark it or come back with more details for the folks who answered.

Was this reply helpful? Yes No