Label Item = Lookup, where the source is from Sharepoint List and the result source column is in a Dropdown Type.

(0) Share

Report

Posted on by -aj

120

Sharepoint List Source:

Employee Name is Single Line Text,

Supervisor and Team is Dropdown

PowerApp;

My lookup formula is

LookUp('AV List','Employee Name'=ComboBox2.Selected.'Employee Name',Supervisor)

Error message is

My formula is working if the result source column (Supervisor) is a single line text field, but not if its different. Is there a documentation for this that I can read?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

EdViegas 436 on at

Like (1)

Report
Copy link

Link copied!
The result of your formula is a record (LookUp). You can't show a record inside a label. Try to specify at the end of your formula the field of the record, for example:
LookUp('AV List', 'Employee Name' = ComboBox2.Selected.'Employee Name', Supervisor).ID

Was this reply helpful? Yes No
-aj 120 on at

Like (0)

Report
Copy link

Link copied!

Im feeling superdumb right now. May I know what is the '.ID'? is that Supervisor or 'Employee Name'? I tried both, but none is working.

One option is to convert the Record to Text, but this isnt working either or Im just using it incorrectly:

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@-aj

If that Supervisor is a choice column as you mention, then append your Supervisor column name in your formula with .Value - i.e. Supervisor.Value

I hope this is helpful for you.

Was this reply helpful? Yes No
-aj 120 on at

Like (0)

Report
Copy link

Link copied!

Wow, that worked, Thank you!!

Was this reply helpful? Yes No