Filtering table based on a Choices Column

(0) Share

Report

Posted on by charizard

Hi,

I am trying to filter a table based on a choices column by selecting the choice through a dropdown menu to get the last item on the list with that choice column result. I can get it to work on every other column I have except for this choice column.

The dropdown menu (Dropdown3) Items input is

Sort(Choices([@'FST'].F),Value,Ascending)

The table Items input is

Last(Filter('FST',F=Dropdown3.Selected.Result))

Edit:

The data is based on a list from Sharepoint

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 152,839 Most Valuable Professional on at

Like (0)

Report
Re: Filtering table based on a Choices Column

Hi @charizard ,

The output of that combo box is .Value, not .Result. You can also get the same record with

LookUp( Sort( FST, ID, Descending ), F=Dropdown3.Selected.Value )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No