Dynamics Community Forum Thread Details

How do I deselect selected values in a multi-select field?

Hi experts!

I have a multi-select field (X) that I wan't to hide / show, require / not require based on an other fields (Y) value.

If field Y = 1 then show and require field X

If field Y = 0 then hide field X and set required to none

This is what I have achieved so far (and made sure works):

But, I'm struggeling with my last requirement: when field Y changes from 1 to 0 I wan't to deselect selected values in field X.

Any suggestions?

Categories:

Microsoft Dynamics CRM

Hello SA-18061446-0,

You're very close! The challenge you're facing is that the getAttribute("column_X").setValue(null) approach doesn't work as expected with multi-select option sets in Dynamics 365. This is because multi-select option sets store their values as an array of option values, not as a single value.

Here's how to correctly deselect all values in your multi-select option set (field X) when field Y changes from 1 to 0:

Corrected Code:

function showFieldOnChange(executionContext) {
var formContext = executionContext.getFormContext();
var Y = formContext.getAttribute("column_Y").getValue();

if (Y == 0) {
formContext.getControl("column_X").setVisible(false);
// Correct way to deselect multi-select options:
formContext.getAttribute("column_X").setValue([]);
} else {
formContext.getControl("column_X").setVisible(true);
}
}

Explanation of the Change:

formContext.getAttribute("column_X").setValue([]);
- This line is the key. By setting the value of the multi-select attribute to an empty array ([]), you effectively clear all selected options.

How to Use:

Add the Code as Web Resources:
- Create two JavaScript web resources in Dynamics 365: one for setFieldRequirementAsRequired and one for showFieldOnChange.

Add the Functions to Form Events:
- Open your form in the form editor.
- Add the setFieldRequirementAsRequired function to the form's OnLoad event.
- Add the showFieldOnChange function to the OnChange event of the column_Y field.
- Add the setFieldRequirementAsRequired function to the OnChange event of the column_Y field.

Publish Customizations:
- Publish your form customizations.

Important Notes:

Logical Names: Ensure that column_Y and column_X are replaced with the correct logical names of your fields.
Testing: Thoroughly test the form to ensure that the multi-select options are cleared correctly when column_Y changes from 1 to 0.

With this correction, your multi-select field (X) should behave as you intend:

When field Y is 1, field X will be visible and required.
When field Y is 0, field X will be hidden, not required, and any selected options will be cleared.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.

My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.

Regards,

Daivat Vartak

Quick Links