Lookup Dropdown and show table value in textbox

[Anonymous]

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?

[eka24]

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]

Hi @Anonymous 

@eka24  is correct.  The Distinct() function creates a single column table of unique values from the datasource and renames the column "Result"

[Anonymous]

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]

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.

[Anonymous]

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

[eka24 · Accepted solution]

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]

is the issue Resolved

[Anonymous]

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