web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Filter on Multiple Sel...
Customer experience | Sales, Customer Insights,...
Answered

Filter on Multiple Select field not workling

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

We have a multi select field on Opportunity entity - Product Group.

When we filter the records on the Opportunity View page based on multi select field - Product group, the results obtained are incorrect.

Please see image below.
ARmultiselect.png

We have selected AR to filter our data, however the results returned do not seem to be correct.

Can anyone provide some help on this issue.

Thanks

I have the same question (0)
  • LuHao Profile Picture
    LuHao 40,890 on at
    RE: Filter on Multiple Select field not workling

    Hi Aakarsh1992,

    I tested it in my environment and did not encounter this problem.

    pastedimage1579164825803v1.png

    pastedimage1579164845395v2.png

    Please clear the browser cache or change another browser to see if it works.

    Also, please check if this problem is also present in Unified interface.

    If you switch to a view with a smaller amount of records and then filter this multi-options field, will it succeed?

  • Community Member Profile Picture
    Community Member on at
    RE: Filter on Multiple Select field not workling

    Thanks for the reply.

    I noticed one thing. The value on the enum which gives incorrect results on the filter is 1. I changed the value on this enum to another number (22).

    Now, the results are fine.

    Can you please try this at your end? Add about 15 enums with value from (1-15). Now, on the filter check the enum with value 1.

    Does it show correct results?

    Thanks again.

  • Verified answer
    LuHao Profile Picture
    LuHao 40,890 on at
    RE: Filter on Multiple Select field not workling

    Hi Aakarsh1992,

    I set the values of the multi-options field in the order of 1 ~ 15.

    pastedimage1579227963355v1.png

    The problem does exit. If I filter out option with the value of 1, this filtering does not work.

    pastedimage1579229186740v2.png

    This is indeed a bug in web client. I will raise a support ticket for it.

    If the bug is resolved, I will follow up here.

    In the meantime, I would recommend you use the custom filter.

    pastedimage1579230820831v3.png

    pastedimage1579230843145v4.png

    pastedimage1579230880060v6.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 125

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 98 Super User 2025 Season 2

#3
Erin Lubben Profile Picture

Erin Lubben 73

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans