web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Table Auto Filter Option

Power Apps

Suggested Answer

Table Auto Filter Option

(1) Share

Report

Report

Posted on by MA-22012002-0

I am developing canvas app. I have table on on page and full of data and columns. Each column has tiny rectange to sort or filter but filter options always disable. Why?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

jpespena 335 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Most probably because this Modern Table Control is still in preview, thus some functionalities are not yet fully available. You can putting a drop down outside the table and use it as a filter field for specific column.

Example:

Say you have a column for Status and Location, create two dropdowns for each and set the Items property of the Table to:
Filter( YourTableDataSource, Or( IsBlank(dropdownStatus.Selected.Value), Status = dropdownStatus.Selected.Value ), Or( IsBlank(dropdownLocation.Selected.Value), Location = dropdownLocation.Selected.Value ) )

Using this formula, it will show all data when no selected filters on any dropdown.

If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

Was this reply helpful? Yes No

Join the conversation