Answered

Make a label visible based on a dropdown selection

(0) Share

Report

Posted on by Germán Microsoft Employee

Hello!

I am trying to do a simple thing, but I am struggling to achieve it correctly:

I have a text input control that is hidden unless an item "Other" is selected in a previous dropdown. The dropdown is set to be for multiple options. It is very simple to make the label visible when "Other" is selected, the issue is that, if various options are selected + other, the hidden control will only appear if other is selected the last

Here I attach the example:

I have tried with these formulas:

1. If(Text(productInput.Selected.Value) = "Other", true, false)

2. CountRows(Filter(productInput.SelectedItems, Text(productInput.Selected.Value) = "Other"))>0

3. productInput.Selected.Value in "Other"

And they all give me the same result, but don't manage to solve this issue I am having. Any suggestion, please?

Categories:

General Questions

All responses (12)

Answers (2)

Verified answer

Germán Microsoft Employee on at

Like (1)

Report
Re: Make a label visible based on a dropdown selection

Hello:
Sorry for my delay in replying as I have been disconnected for personal reasons. Finally, I could get back to the app and try your suggestion. It didn't exactly work for me as it said "a boolean value is expected" something like that, but it gave me the idea to try something similar but still different and IT WORKED:

If(CountRows(Filter(productInput.SelectedItems,Value = MicrosoftProducts.Other))>0, true, false)

I am accepting your as solution as it may help other person maybe with a different configuration in the column

Thanks a lot for your support! Very appreciated
Verified answer

DBO_DV 4,534 Super User 2025 Season 1 on at

Like (1)

Report
Re: Make a label visible based on a dropdown selection

Could you try this:
If(productInput.Selected.Value = 100000002,'COLUMNNAME (TABLENAME)'.Other,true, false)
100000002= NumberValue of the Option "Other" (As you know all options will have a Numeric value)
COLUMNNAME = the column name of your choice column in Dataverse
TABLENAME = the Name of your Dataveretable wehre the choice column is in.
Germán Microsoft Employee on at

Like (0)

Report

Re: Make a label visible based on a dropdown selection

I expect to get back text with Microsoft Products like: Office, Power Apps, etc
DBO_DV 4,534 Super User 2025 Season 1 on at

Like (0)

Report

Re: Make a label visible based on a dropdown selection

That's quite a tricky one.

What do you expect to get back? How does it look in your Datasource?
Germán Microsoft Employee on at

Like (0)

Report

Re: Make a label visible based on a dropdown selection

It gives the same result, but with less columns this time:
DBO_DV 4,534 Super User 2025 Season 1 on at

Like (0)

Report
Re: Make a label visible based on a dropdown selection

Thank you @Germán,

Now we can say quite confidently, that the issue lies within the table somewhere.
It could be that Powerapps has a problem with showing the value because off too many nested columns.
Because of the image could you try to only collect the Selected value from your Dropdown. We could see there that it was also a Table.
Collect(colTest, ProductInput.SelectedItems.Value)

Germn_0-171396056...
Germán Microsoft Employee on at

Like (0)

Report

Re: Make a label visible based on a dropdown selection

Ok, so I have created the collection but it looks a bit weird (maybe I did something wrong).
So, I started with:
And then I got the collection with all the columns in the table from dataverse, not only one:
But still, in the created column "Product" the values I get are ?:

Also, to add on your last comment. I tried to add the dot behind value on the other formula (with .SelectedItems and with .Selected), and no suggestion obtained
DBO_DV 4,534 Super User 2025 Season 1 on at

Like (0)

Report

Re: Make a label visible based on a dropdown selection

I know we are getting there step by step.
Now we know for sure, that you have a whole record to match with your combobox, and not just a Text string.
It would be awesome to know what is inside the record. To achieve this you could either put it into a table or into a collection. Maybe you could also add a dot behind value to see what intelisens proposes to add.
Germán Microsoft Employee on at

Like (0)

Report

Re: Make a label visible based on a dropdown selection

Yes, I am working with a table in Dataverse. Sorry for not mentioning that

I tried to display it in a text label, but when adding ".Value", it shows an error. It works if I do like productinput.Selected.Value, but it doesn't solve the question of the thread

This is the error:
DBO_DV 4,534 Super User 2025 Season 1 on at

Like (0)

Report

Re: Make a label visible based on a dropdown selection

So you're using Dataverse,... Could you try to display productINput.SelectedItems.Value in a text label or a Table/Gallery. Like this you know exactly what your application expects to compare with