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

(0) Share

Report

Posted on by kylerw

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 (1)

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