web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Resetting multi-select...

Power Apps

Answered

Resetting multi-select fields when value detected?

(0) Share

Report

Report

Posted on by simms7400

829

Hi Team -

I have a multi-select field that is required for all end users to populate. If the situation does not warrant a specific value, there is a "Not Applicable" value available to select. The challenge is at times, I have other values along with the "Not Applicable" value selected as an end user forget to remove the "Not Applicable" value or visa-versa.

So my question is, is there a way to clear all selected values when "Not Applicable" is selected along with another value? This way, it forces the end user to re-select the correct values. Thank you!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @simms7400 ,

I did a test for you.
1\ This is my list 'LIST99'. 'Test' is a choice column.

2\ Add a combo box control 'ComboBox1' and set its Items property to:
Choices(LIST99.Test)

3\ Set onchange property of the combo box control to:
If("Not Applicable" in ComboBox1.SelectedItems.Value && CountRows(ComboBox1.SelectedItems)>1,Reset(ComboBox1))

4\ Clear the formula of the DefaultSelectedItems property of combo box control (If there is a formula in the property)

5\ The result is as follows:

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

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft Thank you so much!! This worked great!!!

Join the conversation