Answered

Lookup Dropdown and show table value in textbox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I have a dropdown populated with a column table "Bds":

Distinct(Bds,Categoria)

I want the user to select a category from that dropdown and populate a textbox with data from that same table, for example I have this table example:

Categoria	Bd1
Categoria 1	Result

As I understood if I use this formula on Default of the Textbox should do the trick but it is not bringing the result:

LookUp(Bds,
Categoria =
"Dropdown.Selected.Result",
'Bd1')

It is Looking in Bds table, column Categoria for the selected dropdown result and it should bring me "Result" As the dropdown is populated within the same table there should be a exact match. What am I doing wrong?

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

In the default of the TextBox, use:
Dropdown1.Selected.Result

Change the Dropdown1 to the actual name of the Dropdown
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

@eka24 is correct. The Distinct() function creates a single column table of unique values from the datasource and renames the column "Result"
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

But that will bring the exact same value as the dropdown, now If I choose Category 1 in the dropdown it shows Category 1 in the textbox.
I want to choose Category 1 in the dropdown and bring "Result" in the textbox, meaning that the value is in the second column in the table "Bds", row1.

is it possible?
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

In the default of the TextBox1, use:
Dropdown1.Selected.Result

Then Insert another TextBox2 Default Put:
LookUp(TableName,Categoria=TextBox1,Bds)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@eka24I tried it, but it is bringing again an empty result 😕
The textbox1 is populated but the next one that should bring the result does not.
LookUp(Bds, Categoria = "TextBox1", 'Base de datos1')

I added a screenshot of the table, I want to look Categoria 1 and give the second column of that row.
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Use:
LookUp(Bds,Categoria = TextBox1.Text,'Base de datos1')
It means your table is called Bds
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

is the issue Resolved
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 @Drrickryp
Sorry for the late reply!

Had to do the app again, some issue with the source.

But yes!!! All good now. App is finally completed.

Thank you so much!