One of the best changes to come with the Power Platform 2020 Wave 1 update is the improvements to filtering in Grid Views. 
For users who had been used to filtering Views in the Classic interface, the first release of the new UI seemed somewhat limited. 
Firstly, for anyone new to Dynamics 365 Customer Engagement, what is a View? A list of records of the same type is a View. This may be ALL records within the entity (record type) or may be filtered by criteria. The records may also be sorted in a specific order. The fields (columns) to be displayed are pre-defined when the View is created. 
Subject to security roles, Views are a very powerful way for end users to obtain the information they require, when it is needed, without having to ask IT resources to write specific reports, or Export data to Excel for further manipulation. In many cases the majority of reporting requirements can be achieved using Views. However, the change in functionality in the earlier release did give some limitations. 
Thankfully, that has changed with 2020 Wave 1. 
Within a View most columns (fields) can be filtered. The actual options for filtering depend on the data type. 
Equals / Does not equal 
Contains data / Does not contain data 
Contains / Does not contain 
Begins with / Does not begin with 
Ends with / Does not end with 
Equals / Does not equal 
Contains data / Does not contain data 
Greater than 
Greater than or equal to 
Less than 
Less than or equal to 
Dates have numerous options covering  
week/month/year/fiscal periods 
next/last x days/weeks/months/years 
... and many more 
With the wide range of filter options available with Dynamics 365 2020 Wave 1 users and administrators can build customer Views covering everything including Sales Forecasts and Pipelines, Goal Analysis, analysing data for marketing purposes and a whole host of others depending on your specific system set up and business requirements. 
For Dynamics 365 CE consultancy or training to help your business get the most from your investment in D365 contact CRM365 Solutions
Share this post:

Leave a comment: 

Our site uses cookies. For more information, see our cookie policy. Accept cookies and close
Reject cookies Manage settings