web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Have a name associated...

Power Apps

Answered

Have a name associated with ID be in a lookup table alongside the ID.

(0) Share

Report

Report

Posted on by kylerw

28

I apologize for the confusing title but it is really hard to phrase my issue. Anyways, I am creating a form that has a lookup field in it. The lookup field gets data from an employee info list. The field being looked up is Employee ID. Each Employee ID has a corresponding name in its own column attached to it in the employee info list. What I want to do is have the employee's name show up in the lookup dropdown as well when selecting the employee ID. This will make it easy for the user to know what employee they are selecting. Thanks for any help.

'Employee Info'[TeamMemberName]

'Employee Info'[TeamMemberID]

'Second Table'[TeamMemberName]

'Second Table' [TeamMemberID]

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @kylerw ,

I did a sample for you if your data source is SharePoint list.

AddColumns(Choices(LIST270.Test_Lookup),"Employee Name",LookUp(LIST271,ID=Id,'Employee Name'))

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation