Answered

Multi select combo box clear other values if "none of the above" selected

(0) Share

Report

Posted on by RoarkeP

Hello! I have a multi-select combo box and want to clear all other values if "None of the above" is selected. I have come close with:

ComboBox.OnChange

If("None of the above" in ComboBox.Selected.Value, UpdateContext({varNoneAbove:true}); UpdateContext({varNoneAbove:false}))

Can I update the values in a multi select combo box within the .OnChange of that same multi select combo box?

Any ideas? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

WarrenBelz 154,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @RoarkeP ,

You are only setting a Variable here (not clearing anything), but the code would be on the OnChange

UpdateContext( { varNoneAbove: Self.Selected.Value = "None of the above" } )

What are you then trying to update?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
RoarkeP 14 on at

Like (0)

Report
Copy link

Link copied!
Thank you for responding!

Multi-select combo box
Choices are pulled from a SharePoint list ("A", "B", "C", "D", "None of the above")
When users selects "None of the above" I want to remove any other values also selected ("A" - "D")
When I put your code in the OnChange property of the DataCardValue, the "=" causes an error:

Do you need to know more to suggest other ideas?

Was this reply helpful? Yes No
WarrenBelz 154,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@RoarkeP ,

Firstly, you must have the Variable varNoneAbove already defined as another data type - I tested the syntax here and it worked fine. If you simply want to reset the control, do this OnChange

If( "None of the above" in Self.SelectedItems.Value, Reset(Self) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
RoarkeP 14 on at

Like (0)

Report
Copy link

Link copied!

How do I have the Variable varNoneAbove already defined as another data type? When I put the syntax above in the OnChange of the control, it errs as follows:

Was this reply helpful? Yes No
WarrenBelz 154,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@RoarkeP ,'

You did not say you were using DataVerse - I assumed SharePoint.

I am not a DV user, but you might look at what the valid output of ComboBoxName.Selected.Value is.

Also this blog may be of assistance.

Was this reply helpful? Yes No
RoarkeP 14 on at

Like (0)

Report
Copy link

Link copied!

Ah yes - DataVerse indeed - The blog is useful theoretically but was not enough to resolve my issue. Thanks for all the input!!

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @RoarkeP ,

I did a test for you.

1\ This is my column 'Test10' in table 'Test 66S' . It's a Choices column.

2\ Add a combo box control 'ComboBox1' and set its Items property to:

Choices('Test 66S'.Test10)

Set its Onchange property to:

If("None of the above" in Concat(ComboBox1.SelectedItems.Value,Text(Value),","),Reset(ComboBox1))

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
RoarkeP 14 on at

Like (0)

Report
Copy link

Link copied!

Hello - thanks for the input - I believe both solutions are working for both of you. However, there may be something wrong with my setup/environments because they still are not working for me.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RoarkeP ,

Could you provide details?

Best Regards,
Wearsky

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft I was able to get my combo box working per your example expression. One issue I ran into was when I choose "None of the above" it clears that selection also... I'd like for users to be able to at least make that selection. Any ideas on making that happen?

Here is what I have:
If( "None of the above" in Concat( cmbBusinessBenefit.SelectedItems.Title, Text(Title),", "), Reset(cmbBusinessBenefit))

Was this reply helpful? Yes No