Filtering the table records for the Multi Choice fields/columns is easier if only one option is selected and can be done using the “Equal & Does not equal” filters present. But while filtering the data when more than one option is selected, the “Equal & Does not equal” filter doesn’t work as required so, in that case, we have filters called “Contains values and Does not contain values” that give you an expected output.
So let’s explore how it works!
Let’s say I have a Multi choices column called Hobbies and below are a few Account records on which I have set the data in the Hobbies field:
Here if I want to see the Account records where only the “Reading Books” option is selected then I can use the “Equal” filter.
As you can see below, after applying an Equal filter it only shows the Account record where only the “Reading Books” option is selected in the “Hobbies” column.
But if I also want to see the Account records where multiple options are…
Source link
More About This Author
![](https://i0.wp.com/365community.online/wp-content/uploads/nsl_avatars/ffc40eb76be49f8a40004d26b7db36be.jpg?fit=48%2C48&ssl=1)
-
Inogic is one of the leading Microsoft Dynamics 365 ISV since 10+ years. Its flagship product Maplytics™ is a market leading certified (CfMD) geo-analytical mapping app. Maplytics empowers Dynamics CRM users across industries with the power of geographical data visualization, route optimization and along the route search with turn-by-turn directions, appointment planner, locational search by radius and shapes with drill-down filters and color-coded pushpins, heat maps, shape layers & territory management.
Inogic is renowned for its high quality and low-cost offshore development services and productivity apps like InoLink: QuickBooks + Dynamics CRM, User Adoption Monitor, Attach2Dynamics, Alerts4Dynamics Click2Export, Click2Clone, Kanban Board, SharePoint Security Sync, Lead Automation & Distribution, Map My Relationships, Auto Tax Calculator, Subscription and Recurring Billing and Marketing4Dynamics.
Array
Dyn365CE26 July 2024Enhanced ‘Selected Row’ Trigger Now Available in Power Automate
Dyn365CE25 July 2024Maplytics Optimizes Routes and Boosts Productivity for T-GREX
Dyn365CE24 July 2024Streamline Multilingual Customer Support using Language Detection Prebuilt Model in Power Automate
Dyn365CE23 July 2024WhatsApp instant messaging vs SMS texting: Deciding Your CRM Messaging Approach!