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:

Using Apps Using Formulas

General Questions

All responses (7)

Answers (1)

Michael E. Gernaey 40,272 Super User 2025 Season 1 on at

Like (1)

Report

Formula Lookup

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.
Suggested answer

ronaldwalcott 3,244 on at

Like (1)

Report

Formula Lookup

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.
jda2005py 21 on at

Like (1)

Report

Formula Lookup

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

ronaldwalcott 3,244 on at

Like (1)

Report

Formula Lookup

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
Verified answer

KeithAtherton 3,646 Most Valuable Professional on at

Like (1)

Report

Formula Lookup

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).
jda2005py 21 on at

Like (2)

Report

Formula Lookup

@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.
Suggested answer

KeithAtherton 3,646 Most Valuable Professional on at

Like (1)

Report
Formula Lookup

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'