web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering table based ...

Power Apps

Answered

Filtering table based on a Choices Column

(0) Share

Report

Report

Posted on by charizard

93

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 Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation