Visibility based on dropdown values

(0) Share

Report

Posted on by maries1986

162

Hello everyone,

I have visibility based on a drop down value on a data card

If(
Dropdown10.SelectedText.Value = "705-P4559-BOI Bentley",
true,
false
)

Works great but problem is.....i want the datacard to show based on that value and also another?

i have tried And and Or but doesnt work. What am i missing????? i need the datacard to show if i select lots of values

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
so to show just the way it should be written, I have a label, and 4 radio buttons.

in the following VISIBLE code if ANY of my radio buttons has not been selected the label will not appear

If(Or(IsBlank(Radio3.Selected.Value),IsBlank(Radio3_1.Selected.Value),IsBlank(Radio3_2.Selected.Value),IsBlank(Radio3_3.Selected.Value)),false,true)

in the following visible code if any of the 4 radio buttons has "Show" selected, my label will show

If(Or(Radio3.Selected.Value="Show",Radio3_1.Selected.Value="Show",Radio3_2.Selected.Value="Show",Radio3_3.Selected.Value="Show"),true,false)

hope this helps

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @maries1986

Dropdown10.Selected.Value = "705-P4559-BOI Bentley" && Another Condition like Dropdown10.Selected.Value = "705-P4559-BOI Bentley" && DropdownStatus.Selected.Value = "New"

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@maries1986

First, avoid using SelectedText as it is a deprecated property!

Change your Visible formula to the following:

//note change value to the correct column if necessary Dropdown10.Selected.Value in ["705-P4559-BOI Bently", "another value..."]

That is all you need, just put in the text that you want in that format.

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Too funny!! So many different ways!!

I'd say for @TheRobRush , you can simplify your formula to:

"Show" in [Radio3.Selected.Value, Radio3_1.Selected.Value, Radio3_2.Selected.Value, Radio3_3.Selected.Value]

Nice thing about OR's is that you can really do all the same with the in operator...makes it SUPER easy!

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @maries1986 ,

Please note that SelectedText is a deprecated property, please use Selected instead. Also it is not necessary to use if function in this situation as the result of condition is also a boolean value.

Here is a sample of and operator usage:

Dropdown10.Selected.Value = "705-P4559-BOI Bentley" && TextInput.Text = "sample text" && DropDownNew.Selected.Value = "New check Value"

Hope it helps !

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@maries1986

I notice that you also mentioned "..if I select lots of values".

That I didn't notice! This will need a slightly different approach as you must now have a combobox and not a Dropdown and you need to allow multiple selections.

Your Visible formula would then need to be something like this:

//note change Value to the correct column if necessary CountRows(Filter(Dropdown10.SelectedItem, Value in ["705-P4559-BOI Bently", "another value..."])) > 1

Sorry to miss that in your post.

Was this reply helpful? Yes No
maries1986 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @RandyHayes I need to put selectedtext or i get and error. I decided to just make the visibility true as i didnt have time to get this just now......Cause the app the break with Unknown Error Occurred!

Can you please help! how can changing it the true....cause the app to error and break

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@maries1986

What is the Items property of your Dropdown? That will determine what column you want to check against and use.

As for the error, can you show a little screenshot or something of what you are seeing?

Was this reply helpful? Yes No
maries1986 162 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Thanks for the reply.....i got the error to stop but now i have a bigger problem!

I can see online this is an ongoing problem with users. the dropdown is from a choice column to update a choice column. It updates to blank.

The default property does not like any formula i put in. Any ideas on the default on the dropdown? parent.default doesnt work. ThisItem.Pricing3 doesnt work. i have tried many more and no luck

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@maries1986

Is your Items property based on Choices then?? Choices returns a table of records that have a single column called Value. So, the only column available to you will be Value.

But I am confused on your response - initially we were discussing the Visible property for your control, but now it seems that you are more focused on the dropdown and the updates.

So, the next question would be, what type of column is the underlying field for your datacard? I assume we are referring to a Pricing3 column? Is it a choice column or a text column or something else?

Was this reply helpful? Yes No