Poweapp lookup from dropdown

(0) Share

Report

Posted on by hoaanhnguyen

I need a bit of help; I have been searching for solution but still no results 😭

So, I have 2 SharePoint list.

Employee list

and a Training data

Basically, what I'm trying to do is Lookup the Employee ID from Employee List, based on Trainee (Text Input) and Campus(Dropdown) from Training Data. I tried to lookup from the Trainee (TextInput) first and it worked fine (I think...😅)

But the dropdown is where I'm stumbled

I keep getting this error, I tried few different syntaxes I found on google 😅. Still no luck

LookUp(Employees,CampusE = Dropdown2.SelectedText.Campus,'Employee ID')

LookUp(Employees,CampusE = Dropdown2.Selected.Value,'Employee ID')

LookUp(Employees,CampusE = Dropdown2.SelectedText.Value,'Employee ID')

I have no idea what I am doing as a begginner to this powerapp thing so I need a lot help 😭

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @hoaanhnguyen ,

It seems you are almost most there: Assuming the Employee_ID column in 'Training Date' is a LookUp column, you should not select the EmployeeID property, but instead pass the entire record that is returned by the LookUp function:

LookUp(Employees,CampusE = Dropdown2.Selected.Value)

Also, use the Selected property for drop downs in stead of the deprecated SelectedText property.

Was this reply helpful? Yes No
hoaanhnguyen 57 on at

Like (0)

Report
Copy link

Link copied!

Sorry I forgot to mention about the column types, EmployeeID column on both lists are just 'Single line of text" column. I got the impression that even if I don't connect them with lookup column, I can still connect them through powerapp since they both have Name(single line of text), Campus(Choice column) and EmployeeID (single line of text) column

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @hoaanhnguyen ,

In that case the issue is with the CampusE column which expects a record. You can remedy that by selecting its' Value:

LookUp(Employees,CampusE.Value = Dropdown2.Selected.Value,'Employee ID')

Was this reply helpful? Yes No
hoaanhnguyen 57 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, the data showwed up 😆

Was this reply helpful? Yes No