Table Auto Filter Option

(1) Share

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 (1)

Answers (0)

Suggested answer

jpespena 335 on at

Like (0)

Report
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