
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
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