Make a label visible based on a dropdown selection

[Germán]

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?

[DBO_DV]

You need make the search on all selected Items. so like this:

"Other" in ComboBox1.SelectedItems.Value

[Germán]

Thank you for your reply, but that's still not working as I am getting an error where I am trying to compare two different variables:

[DBO_DV]

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

[Germán]

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]

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]

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]

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)

[Germán]

It gives the same result, but with less columns this time:

[DBO_DV]

That's quite a tricky one. 

What do you expect to get back? How does it look in your Datasource?