Using a Dropdown to perform a lookup

(0) Share

Report

Posted on by Station1901

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:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

SanmeshG 1,947 Moderator on at

Like (0)

Report

Re: Using a Dropdown to perform a lookup

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,

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

Re: Using a Dropdown to perform a lookup

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.

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report

Re: Using a Dropdown to perform a lookup

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

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

Re: Using a Dropdown to perform a lookup

Try this

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

Thanks!

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report

Re: Using a Dropdown to perform a lookup

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

Was this reply helpful? Yes No
Verified answer

Talha_Dar 870 Super User 2024 Season 1 on at

Like (1)

Report
Re: Using a Dropdown to perform a lookup

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.

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report

Re: Using a Dropdown to perform a lookup

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

Was this reply helpful? Yes No