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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Fewer filtering options on grid for number-based data

(0) ShareShare
ReportReport
Posted on by 5

Hi, 

We just switched our dev environment to the UCI last month. Everything looks great but we noticed that we have fewer filtering options on a grid when it comes to number data, than we had when we were in legacy. 

For instance, we have on field called "Priorities" where we rank how likely we are to talk to certain contacts by assigning them a number 1.00-99.00. We will then send out email waves based on their priority number. Sometimes, we will want to send the same email to people we mark as 1.00s and 5.00s, but not anymore marked 2, 3, or 4. In legacy, it was easy to do such filtering, due to custom filtering. In this example, we only wanted to send emails to people marked 4 and 10:

pastedimage1605213797756v2.png          pastedimage1605213723040v1.png

Notice in the second snip, the priorities are filtered in the background. However, in the UCI, we only get these options: 

pastedimage1605213957490v3.png

Is there a way we can filter this field by more than one number, especially numbers that aren't consecutive in UCI? Thanks for your help. Let me know if I need to clarify anything.

I have the same question (0)
  • Suggested answer
    Divya Gupta Profile Picture
    Microsoft Employee on at

    You can use the "advanced filtering panel" in Unified Interface grids. Click the filter icon next to the search box. Add rows for your filters, check the boxes against these new filter rows and click ellipses next to one of them -> click 'Make group'. Set the filters in the new group as 'Or' condition. You can refer to the screenshots below where I filtered My Opportunities view on Est revenue = 25000 or 26000.

    pastedimage1606806532348v1.pngpastedimage1606806532352v2.png

    pastedimage1606806549706v3.png

    List before the additional filters above:

    pastedimage1606806597795v4.png

    List with additional number filters added:

    pastedimage1606806622329v5.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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 109

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 61 Super User 2026 Season 1

#3
sannavajjala87 Profile Picture

sannavajjala87 29

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans