Currently, only a custom filtering dialog is available, which only allows to define a filter using text. There is no way to enter multiple filters using a lookup dialog. There also is no option available to query for columns with blank values.
In the classic web interface, the column filtering is done using excel-like functionality. We basically need that in the unified interface as well.
Comments
Definitely AGREE! Also, when filtering columns in a view, limit the values for a column filter to column values in the current filtered view. AN example is column filtering as implemented in Excel worksheets.
Category: Unified Experience: Search, navigation and performance
Filter options for User and Date column are limited in unified interface comparing to legacy interface. 1. For User column, there is no ability to filter by current user, select a user from the list of users. 2. For Date column, it is possible to filter only by On, On or After and On or Before. Other options which were present in legacy interface are not available in unified interface.
Category: Unified Experience: Search, navigation and performance
I wholeheartedly agree! The new filter interface is way too complicated for a basic end user that just wants to filter certain things at certain times. I'm an advanced user and just trying to figure out how to filter on blanks was a headache! Previously if the user wanted to view only records from VA and MD, they would just check those state boxes in the drop down. Now they have to go to the filter, select Equals, Contains or other and type "MD", the select OR then repeat for "VA". It is way to labor intensive.
Category: Unified Experience: Search, navigation and performance
Revathi Sankar (administrator) on 3/7/2023 9:55:18 AM
Thank you very much for the suggestion. The filtering has been improved since the time this idea was logged and it can now filter rows with blank values.
Please refer to these links for further read:
https://docs.microsoft.com/en-us/power-apps/user/grid-filters-advanced#filter-editor
https://docs.microsoft.com/en-us/power-apps/user/grid-filters-advanced#select-filter-conditions-in-the-filter-editor
Thanks,
Revathi Sankar
PM, D365 Sales