web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Need Lookup function t...

Power Apps

Unanswered

Need Lookup function to bring back DisplayName from Lookup list to destination list person field in form

(0) Share

Report

Report

Posted on by ShawnPelletier

85

I have a lookup list named 'State Email Master' with the state (text), email address (text), and Rep (person field, multi-choice) fields. I have Three additional fields in my main form named State, 'Rep Email' (text), and 'Rep' (person field). I successfully have the 'Rep Email' field populated when the state field matches from the form to the lookup list using the below formula:

LookUp('States Email Master', State = Dropdown1.Selected.State, 'Email Address')

However I can't get the 'Rep' person field to populate from the lookup list using the same formula, obviously trying different field name combinations for the rep field.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@ShawnPelletier

The question is - your Rep column is a multi-select column...so, which choice would you want to look up?? The first one, the last one, or all of them?

First one:

First(LookUp('States Email Master', State = Dropdown1.Selected.State, Rep)).DisplayName

Last one:

Last(LookUp('States Email Master', State = Dropdown1.Selected.State, Rep)).DisplayName

All of them:

Concat(LookUp('States Email Master', State = Dropdown1.Selected.State, Rep), DisplayName, ",")

I hope this is helpful for you.

Was this reply helpful? Yes No
ShawnPelletier 85 on at

Like (0)

Report
Copy link

Link copied!

This is what I used for the 'Reps' field in my form:
Concat(LookUp('States Email Master', State = Dropdown1.Selected.State, 'Sales Reps'), DisplayName, ",")

It's coming up with a generic message stating there is an error somewhere, if I use Concatenate instead it says the function has some invalid arguments.

Was this reply helpful? Yes No

Join the conversation