{"id":33533,"date":"2022-12-28T15:55:40","date_gmt":"2022-12-28T10:25:40","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=33533"},"modified":"2023-01-02T12:18:00","modified_gmt":"2023-01-02T06:48:00","slug":"how-to-apply-filters-on-multi-choices-columns-in-dynamics-365-ce","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/12\/how-to-apply-filters-on-multi-choices-columns-in-dynamics-365-ce\/","title":{"rendered":"How to apply filters on Multi Choices Columns in Dynamics 365 CE"},"content":{"rendered":"

Filtering the table records for the Multi Choice fields\/columns<\/strong> is easier if only one option is selected and can be done using the \u201cEqual & Does not equal<\/strong>\u201d filters present. But while filtering the data when more than one option is selected, the \u201cEqual & Does not equal<\/strong>\u201d filter doesn\u2019t work as required so, in that case, we have filters called \u201cContains values and Does not contain values<\/strong>\u201d that give you an expected output.<\/p>\n

So let\u2019s explore how it works!<\/p>\n

Let’s say I have a Multi choices column called Hobbies<\/strong> and below are a few Account<\/strong> records on which I have set the data in the Hobbies<\/strong> field:<\/p>\n

\"Dynamics<\/p>\n

Here if I want to see the Account<\/strong> records where only the \u201cReading Books<\/strong>\u201d option is selected then I can use the \u201cEqual<\/strong>\u201d filter.<\/p>\n

As you can see below, after applying an Equal<\/strong> filter it only shows the Account<\/strong> record where only the \u201cReading Books<\/strong>\u201d option is selected in the \u201cHobbies<\/strong>\u201d column.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

But if I also want to see the Account<\/strong> records where multiple options are selected and the \u201cReading Books<\/strong>\u201d option is one of the selected options among them then I can use the \u201cContains values<\/strong>\u201d filter.<\/p>\n

As visible below, after applying the \u201cContains values<\/strong>\u201d filter it shows account records where only the \u201cReading Books<\/strong>\u201d option is selected and also shows records where the \u201cReading Books<\/strong>\u201d option is selected along with other hobbies options.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

Similarly, if I want to see all the account records except records where only one option is selected as \u201cReading Books<\/strong>\u201d then I can use the \u201cDoes not Equal<\/strong>\u201d filter.<\/p>\n

As seen below, after applying the \u201cDoes not equal\u201d<\/strong> filter it shows all the account records (including records where multiple options are selected including the \u201cReading Books<\/strong>\u201d option) except the account where \u201cReading Books<\/strong>\u201d is the only option selected in the \u201cHobbies<\/strong>\u201d column.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

But if I also don\u2019t want to see the Account<\/strong> records where multiple options are selected and the \u201cReading Books<\/strong>\u201d option is one of the selected options among them then I can use the \u201cDoes not contains values\u201d<\/strong> filter.<\/p>\n

As seen in the below screenshot, after applying the \u201cDoes not contain values\u201d <\/strong>filter it shows all the account records except the account where \u201cReading Books<\/strong>\u201d is the only option selected in the \u201cHobbies<\/strong>\u201d column or accounts where the \u201cReading Books<\/strong>\u201d option is selected along with other hobbies options.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

Conclusion<\/strong><\/h2>\n

\u2018Contains values\u2019<\/strong> and \u2018Does not contain values\u2019<\/strong> filters make the user experience easier and more engaging while working on filtering the data in Multi Choices Columns.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Filtering the table records for the Multi Choice fields\/columns is easier if only one option is selected and can be done using the \u201cEqual & Does not equal\u201d filters present. But while filtering the data when more than one option is selected, the \u201cEqual & Does not equal\u201d filter doesn\u2019t work as required so, in\u2026 Read More: How to apply filters on Multi Choices Columns in Dynamics\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,16,18,2361],"tags":[2185],"class_list":["post-33533","post","type-post","status-publish","format-standard","hentry","category-customer-service","category-dynamics-365","category-dynamics-365-v9-2","category-technical","tag-dynamics-365-ce"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t