cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Model Driven App - Filter View column to earlier than today

Within a model driven app, is it possible to filter a view on a custom entity so that it filters records which have a date earlier than today (and dynamically works out what date it is at runtime)?

 

I had a look for the option but can't see it, it only allows me to use a fixed date

 

OnOrBeforeToday.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @Spikyface ,

 

Your requirement can be implemented by Out-Of-Box Older Than X Days criterion.

By using the following two filter conditions on any entity’s date field will provide the list of all records Older Than Today:

Snipaste_2020-10-09_15-55-38.png

We need the additional Yesterday filter because the Older Than X Days operator only accepts a value from 1 to 500 and doesn’t support 0.

Hope this helps.

Sik

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Hi @Spikyface ,

 

Your requirement can be implemented by Out-Of-Box Older Than X Days criterion.

By using the following two filter conditions on any entity’s date field will provide the list of all records Older Than Today:

Snipaste_2020-10-09_15-55-38.png

We need the additional Yesterday filter because the Older Than X Days operator only accepts a value from 1 to 500 and doesn’t support 0.

Hope this helps.

Sik

View solution in original post

Highlighted

@v-siky-msft that's great, thanks for your help!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,754)