Hi @hong_yip ,
So would you like to filter the data table by a dropdown box?
If I understood correctly, you could add a Dropdown box with the Distinct function:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-distinct
Assuming that you are working with SharePoint list, and if the type of the column which you would like to filter with is Text, and allow single selection in the Dropdown, you could apply below formula in Items of Dropdown:
Distinct(ListName,ColumnName)
and in the data table's Items, modify to:
Filter(TheOriginaItems,ColumnName = Dropdown.Selected.Result)
There would be so many possible situations based on the column types and/or if you would like the dropdown allows single/multiple selection, please share more details about everything you mentioned.
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
