cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaWu
Impactful Individual
Impactful Individual

PowerApps/Dynamics 9 MultiSelect Option Set: empty selection allowed in Dynamics but not PowerApps

I am using MultiSelect Option Set attributes introduced in Dynamics versions 9.
In Dynamics itself and Dynamics forms there are no issues with selecting none of the Multiselect options or changing them to none selected.
However, in PowerApps, using a standard "Form screen" and "Fields" with automatically generated data cards for the Multiselect Option Set attributes and "SubmitForm", selecting none of the options yields

"Edm Object passed should have the options selected"


Question:

  1. Does Multiselect Option Set (in Dynamics) officially support "none selected"?
  2. If yes, is my observed behaviour a bug/missing feature in PowerApps?

Currently I have to use workarounds similar to:

UpdateContext({
    MultiselectEmpty: (CountRows(ComboBoxInput.SelectedItems) > 0), 
    OldId: SelectedItem.id
});
Patch(
    DataSource,
    If(NewItem || MultiselectEmpty, Blank(), OldId),
    { key: value, … },
    If(!MultiselectEmpty, {_multiselect_attribute_label: ComboBoxInput.SelectedItems}, {})
);
If(!NewItem && MultiselectEmpty, Remove(DataSource, {id: OldId}))
1 ACCEPTED SOLUTION

Accepted Solutions
SaWu
Impactful Individual
Impactful Individual

Seems like with PowerApps 3.19013.14 and the new Preview Feature (default on) "Relational data, Option Set" etc, and standard form control, the issue is gone, and empty selections are allowed.

View solution in original post

3 REPLIES 3
v-xida-msft
Community Support
Community Support

Hi @SaWu,

 

Could you please share a screenshot of your app's configuration?

 

 

Please check if you have set the Field Requiredment property of the Multiselect Option Set type column within your to Required. If yes, please set it to Optional, then check if the issue is solved.

 

If you could provide more details about your scenario, we could provide a proper workaround for you.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SaWu
Impactful Individual
Impactful Individual

The property is set as "optional":
My issue isn't per se with this "optional setting".
My issue is that an empty selection, selecting none seems to be only possible when using Dynamics directly instead of PowerApps

Here are the field attributes
2018-08-10 11_24_25-Feld_ Nachbearbeitung von Messe-Erfassung.png
There are the Form, field, Combo Box properties
2018-08-10 11_48_36-TestComboBox - Saved (Unpublished) - PowerApps.png2018-08-10 11_49_22-Posteingang - wu@kriegerkollegen.de - Outlook.png2018-08-10 11_49_40-TestComboBox - Saved (Unpublished) - PowerApps.png
This shows the error, the tick icon has SubmitForm as OnSelect action.
2018-08-10 11_51_21-TestComboBox - Saved (Unpublished) - PowerApps.png2018-08-10 11_52_18-TestComboBox - Saved (Unpublished) - PowerApps.png
 

SaWu
Impactful Individual
Impactful Individual

Seems like with PowerApps 3.19013.14 and the new Preview Feature (default on) "Relational data, Option Set" etc, and standard form control, the issue is gone, and empty selections are allowed.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,976)