Text Label based on dropdown Menu

(0) Share

Report

Posted on by BPowerApps

So I currently have an excel spreadsheet with the table below,

Tablename: TableWalk

Title ¦ Road

A1 UP

B1 Down

C1 Down

D1 UP

I currently have a drop down showing a list from the Title Column. This is achieved by,

TableWalk.Title

I now have a text label and want to show the value from the Road column based on what was chosen from the dropdown. For example, if I chose A1 from the dropdown, the text label should show 'UP'.

I tried Dropdown2.Selected.Road but comes up with an error, after typing Dropdown2.Selected. the only suggestion is to put 'Title' which of course is not what I want.

Any help would be appreciated.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @BPowerApps

Set your Items to TableWalk and edit the combox field, select the primary text as Title. By Setting the Items to TableWalk.Title you drop the Road column hence the title being the only one available.

Like this

Leave your text as is.

R

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BPowerApps ,
You can use LookUp function for your Text label/input field -
LookUp(TableWalk, Title = Dropdown2.Selected.Title, Road)

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @BPowerApps the solution by @NandiniBhagya20 will work, but you will pay a performance price for it. While it is working consider accessing information without looking it up again when you do this type of solution in the future. Editing your comobobox fields will allow you access to the data linked to the combobox without another call to the table.

Was this reply helpful? Yes No
BPowerApps 29 on at

Like
a
(0)

Report
Copy link

Link copied!

It's not a combobox I'm using, it's a dropdown, therefore this wouldn't be an issue? If you, do you have any recommendations?

Was this reply helpful? Yes No