Answered

Filter By not working on Numerical Columns

(1) Share

Report

Posted on by Tamara Sagert

Recently we have been getting the following error when trying to filter in numerical columns. It will not allow people to put in a number, yet we can sort lowest/highest. We have been using the Edit filters as a work around.

Categories:

Other

All responses (8)

Answers (1)

CH-25070121-0 3 on at

Like (0)

Report

Filter By not working on Numerical Columns

The change to New Look and the changes to how views filter data is a very bad enhancement. New view filtering, or lack thereof, does not retrieve all the information, which is a really big problem.

This has a significant impact on how our organisation uses Views and filtering!

Views are used extensively across our CRM for ad-hoc style reporting and analysis, also assisting operational processes. This information used in account management and sales opportunities helps determine and create leads that turn into sales revenue and growth for our company.

Yes, we have sales pipeline management and processes for the purists out there but views are a great tool. Limiting the data and filtering then does not show all available information. This impacts how the Charts functions work. This impacts how and when using Power BI 'Visualise this view'.
csnyder 2 on at

Like (0)

Report

Filter By not working on Numerical Columns

I am still seeing this issue for all users regardless of browser. Is there a solution for this problem?
opalbiz608 8 on at

Like (0)

Report

Filter By not working on Numerical Columns

did you ever find out a solution? i am running into the same problem

- i tried the 'new look'

- i also tried the power apps grid'
Leah Ju Microsoft Employee on at

Like (0)

Report

Filter By not working on Numerical Columns

Hipetemurray,

Thanks for sharing!
Verified answer

All My Systems 84 on at

Like (1)

Report

Filter By not working on Numerical Columns

Hello

We've had a similar problem. It affected all our customers on CRM11 tenancies.

There are two solutions.

Here's the solution we got from a Microsoft engineer
"As discussed, Filter by is not working on Numeric columns like currency etc on Read only grid (By default) control which is an old control and that will be deprecated in the future releases. we have introduced a new control called "Power apps grid control" recently in Wave 2 release and after adding the "Power apps Grid control" on the work order entity, we were able to filter the records on the numeric columns without any issues."
We tried this and changing to the new Power apps Grid control fixed the problem

The second option is to use the New Look toggle at the top of your Dynamics screen. The also removes the problem. We've not investigated how it removes the problem, though, I assume it changes the grid in some way

Good luck
Pete
Leah Ju Microsoft Employee on at

Like (0)

Report

Filter By not working on Numerical Columns

Hi Partner,

Given your feedback, it may be a bug caused by a system update.

So I suggest you follow the steps below to create a support ticket and the Microsoft support team can help confirm it.
Get Help + Support - Dynamics | Microsoft Docs
Tamara Sagert 8 on at

Like (0)

Report

Filter By not working on Numerical Columns

Hello Leah,

Thank you for reviewing.

1. Nothing is greyed out, but as soon as we type a number it gives that error "Please enter value"

2. I have tried different fields and entities, everything works properly until there is a numerical value field, as stated above, as soon as you start typing a number it gives that error, this happens in all entity numerical fields.

3. This has been happening for all users.

4. We have tried it in different browsers, and cleared all cache. I have even tested this in our Sandbox and it does the same thing.

5. It was working previously, but noticed it started acting up a month or so ago.
Leah Ju Microsoft Employee on at

Like (0)

Report

Filter By not working on Numerical Columns

Hi Tamara Sagert,

It's so strange.

I can filter number type column normally:

My column type:

Current version:

1. Have you tried filtering with other functions? Also all greyed out?Show the same information?

2.Tried other fields of the same type? Of the same entity? Different entities?

3.All users? or only some users?

4.Have you tried to change other browsers? or clear cache of the current browser?

5.It was normal before, just recently appeared?

I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah