Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Data table filter modification



I have such a formula in data table:


It allows me to search through an input box, and label descending;ascending.


In my table I have also a column "Date of creation":


 Is it possible to modify my formula to be able not only to sort date (utworzony) descending/ascending, but also to be able to use date picker or something to filter date in this column?

Date picker would be great cause it is very intuitive.

This way I could not only sort desc/asc, but also pick a date that I am interested in.


Once again thank you in advance guys.

Thanks to you each day I am becoming better and better, but... Filter functions are still the worst thing for me. I still do not understand why I need to add it all in one table, and why couldn't it be made on button/labels. Or why in the world data table does not have any standard filter like sharepoint list or anything (at least headings filters asc/desc) ;(


Modify the code to:

Text(datea,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate)), 
Utworzony, If(SortDescending2,Descending,Ascending))


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.


It 'worked' in some sort of way:


Text(Utworzony;ShortDate) = Text(DatePicker1.SelectedDate;ShortDate)); 
Utworzony; If(SortDescending2;Descending;Ascending))

Maybe I designed it bad - I do not know, but now this DatePicker1 only shows records from Today(). When I delete DefaultDate it shows no records - so it never shows all records... I wanted it to be optional and with empty DatePicket1 to show all records.

Is it possible, or maybe there should be used another solution>


Thank you for your help!

I don't understand your explanation of the Datepicker in the formula. 

Are you referring to the formula or different issue?

I tested it so if you say it worked some how, do you have errors


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Ok. I will try to explain better:


Before using your formula my page showed a list of propositions that I could filter by entering values in fields or by using button (desc/asc date). But when you opened this page it showed all propositions by default.


After using your solution when you enter a page with propositions it shows by default only a propositions that fit within a DatePicker1 value. It is set by default on Today().

So when you go into the page you see only Today propositions. Filters should be optionals and that's not how they are supposed to work I believe.


When I delete date value from DatePicker no data is shown, so there is no way to shows all data anymore. I lost ability to view all propositions.


I thought that I could use 2 date pickers and set them on default with some weird values that would show all records? So this way it would sort data from X (for example 01.01.1900 to Today())

Or is there other workaround?

I only worked on your own formula you posted so it works for you. It wasn't my formula in the first place as you stated. Check your first post.

If you want Add additional issues, you can put in a new post and explain further. 



If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Power Apps News & Annoucements carousel

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

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.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,538)