web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Label Item = Lookup, w...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 120

Sharepoint List Source:

 

Employee Name is Single Line Text,

Supervisor and Team is Dropdown

aj_1-1648488135773.png

 

PowerApp;

My lookup formula is 

 

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

 

 

aj_2-1648488309749.png

 

Error message is 

aj_3-1648488419579.png

 

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:
I have the same question (0)
  • EdViegas Profile Picture
    436 on at

    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

     

  • -aj Profile Picture
    120 on at

    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.

     

    aj_0-1648490179423.png

     

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

    aj_1-1648490331162.png

     

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @-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.

  • -aj Profile Picture
    120 on at

    Wow, that worked, Thank you!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard