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 / Using a Dropdown to pe...
Power Apps
Answered

Using a Dropdown to perform a lookup

(0) ShareShare
ReportReport
Posted on by 209

Hello,

I have a dropdown box on my powerapp which contains a list of Surnames from a Sharepoint list named Drivers.  I would like to add some text labels to the sharepoint list which will lookup the surname n the dropdown list and then populate the label with the relevant information from the same sharepoint list e.g. Forename.

 

This sounds like such a simple thing to do but i'm struggling a bit, any help would be much appreciated.  I've tried using 'LookUp(Drivers,(Surname)=Text(Dropdown1.Selected).Forename)' in the text label but it doesn't work and doesn't seem to like the '='


Thanks

Categories:
  • SanmeshG Profile Picture
    1,956 Moderator on at

    Hi @Station1901 ,

     

    What is the error that you are getting?

     

    Please try,

     

    LookUp(Drivers,Surname=Dropdown1.Selected.Value).'ColumnName'

     

    Here ColumnName refers to the name of the column in your SP list which you want to display/retrieve.

     

    If this helps , please give this a thumbs up and accept this as a solution.

     

    Thanks,

  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Hi,

    Try this

    LookUp(Drivers, Surname = Dropdown1.Selected.Value, Forename)

    Or

    LookUp(Drivers, Surname = Dropdown1.Selected.Value).Forename

    Thanks!

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

  • Station1901 Profile Picture
    209 on at

    Ive tried all of these options though I still get the same error, a red line underneath the = the error reads - Incompatible types for comparison these types can't be compared : Text Error

  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Try this

    LookUp(Drivers, Surname = Text(Dropdown1.Selected.Value), Forename)

    Thanks!

  • Station1901 Profile Picture
    209 on at

    Thanks but now it states that 'value'isnt valid and isnt recognised??

  • Verified answer
    Talha_Dar Profile Picture
    870 Super User 2024 Season 1 on at

    Hi @Station1901,

     

    Please try using the following code and see if it resolves the issue:

     

     

    LookUp(Drivers,Surname=Dropdown1.Selected.// Add The Column Name That is Used To Render Values in The DropDown, Forename)

     

     

    If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Station1901 Profile Picture
    209 on at

    Brilliant, that works exactly how I want it o.  Thankyou

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 204 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard