Way to add filtering on column header similar to Excel or D365/Model-driven app?

[mcross9095]

I have a requirement to add filtering to the column headers in a view in a canvas app, similar to Excel or D365/Model-driven apps, where the type of filter depends on the data type (e.g., text, list, date, etc.). I've done a lot searching and haven't found anything like this. Any thoughts?

[PowerAddict]

Use buttons as headers and then set variable on the OnSelect property of the labels. In the Items property of your gallery or data table, use these variables to filter the data source

Let me know if you need a working example.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

[mcross9095]

@PowerAddict Thank you for your quick response. I'm having trouble visualizing what you mean, so an example would be much appreciated. By the way, I follow you on Twitter and you do some amazing things with Power Apps! Thank you for all of your contributions!

[PowerAddict]

Thank you for your kind words, I am glad you like my work! Let me spin up a quick example and I will share it here in sometime.

Hope you and your loved ones are safe!

Thanks,
Hardit Bhatia
https://thepoweraddict.com

[PowerAddict · Accepted solution]

Here you go. I have tried to show all the different types of filters that are available in excel for text (others can also be done using similar approaches). 

Let me know if this looks good, and I can put together the expressions I used to get this behavior. (The look and feel can be modified so the filters show right next to the header to mimic excel like look and feel, if needed). 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

[mcross9095]

Thank you! This is an interesting method. The GIF definitely helps me understand. I'm so used to having this as a standard feature in D365. Maybe Microsoft will eventually add the same feature to Canvas apps.

[PowerAddict]

For sure, that would be great! Let me know if you want to know the functions I used to achieve this. In either case, I am glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com