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


Report
All responses (
Answers (