Answered

Cannot Apply Filter on a Numeric and a Date field

(0) Share

Report

Posted on by fmc1

I am trying to take advantage of views in Dataverse to limit results in my PowerApp. Finding it much easier and cleaner to create a view than building a complex Filter on a data table. But for some reason I cannot apply a filter on two columns in the view: SalesDate and OrderQty. The table definition shows them as a Date and Numeric field and I can filter them on my data table but both fields Filter by option are greyed when I select the column properties:

The core ID and and Created on columns allow Filter by.

Appreciate any assistance.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Bipin D365 971 on at

Like (0)

Report
Copy link

Link copied!

Hi @fmc1 ,

Try clicking on Edit Filters buttin as highlighted below and then apply your filter

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,714 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @fmc1,

I tried the same from my end and i can able to achieve it

You can try Refreshing or Publishing the View and try again,

Else Try Recreating the View and try again.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
fmc1 37 on at

Like (0)

Report
Copy link

Link copied!

I tried using the Filter by section in your image and the field does not show there either. I also tried creating a new view but still cannot filter on the two fields.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @fmc1 ,

Please make sure that "Searchable" is enabled for the field or it will not be able to be filtered. I verified this with the following:

Scenario where Test Date is not checked "Searchable" on the column configuration:

After changing to "Searchable" on column configuration:

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @fmc1 ,

Searchable defined here:

Was this reply helpful? Yes No
fmc1 37 on at

Like (0)

Report
Copy link

Link copied!

Setting the column to Searchable fixed the problem.
Curious as to why these columns were not set as searchable but others were? The table came from an import of a large Excel spreadhseet.

1 people found this reply helpful.

Was this reply helpful? Yes No
Ixnaycy 7 on at

Like (0)

Report
Copy link

Link copied!

Exactly what I was looking for, Cheers 🙂

Was this reply helpful? Yes No