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
Accepted Solutions
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:
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
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:
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
Helpful resources
Power Apps News & Announcements
Keep up to date with current events and community announcements in the Power Apps community.
Microsoft 365 Conference – December 6-8, 2022
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
