Answered

Logic to determine if Multiple Selection Contains

(0) Share

Report

Posted on by Dr0idy

I have some list data from SharePoint that contains a multiple selection choice column. I want to determine if certain selections have been made and hide additional edit cards depending on the list items selected. I am able to do this easily with other controls that are simple yes no radio buttons using.

DataCard1.Update = false

I can get it to work for a single selection from these drop downs using

DataCardvalue1.Selected.Value = "Test Selection"

But this changes when I select more than one result. I need a formula that does the same as above but instead of equals it uses contains.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Dr0idy 39 on at

Like (7)

Report
Copy link

Link copied!
Ok so I was able to partially solve this myself.
IsBlank(Find("Selection Required",DataCardValue1.Selected.Value))
Only issue is that as more options are selected they override
DataCardValue1.Selected.Value
So it works initially and then if say option1 and option2 are selected only option 2 formulas work.

Eventually managed to get this to work using
CountIf(DataCardValue.SelectedItems,Value="Selection Required")>0

Was this reply helpful? Yes No
Mayurs05 30 on at

Like (4)

Report
Copy link

Link copied!

Yes, This worked for me,
If you have multiselect dropdown values and you want to have conditional visibility you can use the following condition in visible property of that Card or whatever,

If(CountIf(DataCardValue.SelectedItems,Value="Selection Required")>0,true,false)

Was this reply helpful? Yes No
ullmer 3 on at

Like (0)

Report
Copy link

Link copied!
The
CountIf(DataCardValue.SelectedItems,Value="Selection Required")>0
solution is the only statement I found that works for showing a field based on a multi-select drop down. Thanks for posting this!

Was this reply helpful? Yes No
JP 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you, exactly what I was looking for

Was this reply helpful? Yes No