Filter collection by dropdown

[Frankie70]

Hi community,

I've a collection collected with values from 2 SharePoint lists.

I would like to create a dropdown over each column (distinct values) in the gallery that displays the collection.

I am failing though to filter the collection based on a dropdown. When I filter, the dropdown contains only the before selected value.

How can i achieve what I am planning to do? I am a bit stuck here...

Can anybody help me out?

[Frankie70]

Hi @StalinPonnusamy 

the combobox does not work here.

And the Asc/Desc sort is without function

UpdateContext({SortByOrder:!SortByOrder})

Any idea whats wrong?

[StalinPonnusamy · Accepted solution]

Hi @Frankie70 

• Use SortByColumns to sort the list

SortByColumns(
    Filter(
        alldata,
        (IsBlank(Dropdown1.Selected.Result) || Dropdown1.Selected.Result = PStatus.Value)
&& (Other Conditions)
    ),
    "Title",
    If(
        SortByOrder,
        Descending,
        Ascending
    )
)