Sort Variable in PowerApp List

(0) Share

Report

Posted on by kgiles123

224

This is my Variable:

ClearCollect(ProviderCollection,Filter('Provider Inclusion By State','State (State0)' = NameList1_8.Selected.Value).Provider);ClearCollect(DistinctSkillingCollection,
Filter('Provider_Resource_Guide','Name (Title)' in ProviderCollection.Provider &&'AR Start' <= Value(TextInput1.Text) &&'AR End' >= Value(TextInput1.Text)));

UpdateContext({FilteredSkillingCollection: Distinct(DistinctSkillingCollection,Skilling)});

Not sure how to sort this according to 'Skilling'. I'm just plugging the variable, FilteredSkillingCollection, into my list but no sorting occurs no matter if I try to build the sort in the variable or the list. Please and thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

fnanfne 260 on at

Like (1)

Report
Copy link

Link copied!
Not too sure what you're asking, sorry if I misunderstood.

If you have a collection, display that collection in a Gallery, and then do the sorting operation there. I have similar code to the following on my Galleries...

In the Gallery's Items property, add the following code.

Sort(Filter(collectionName, date = Today(),Skilling,SortOrder.Descending)

This will filter your collection based on the date, and then sort the collection based on the Skilling column.

Was this reply helpful? Yes No
Verified answer

timl 36,725 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@kgiles123

I assume what you mean by this is that you've set the Items property of a gallery control to FilteredSkillingCollection

>>I'm just plugging the variable, FilteredSkillingCollection, into my list but no sorting occurs

If that's the case, you can sort by the Skilling column by using this formula.

SortByColumns(FilteredSkillingCollection, "Value" )

Was this reply helpful? Yes No
kgiles123 224 on at

Like (0)

Report
Copy link

Link copied!

Thank you Timl!

Was this reply helpful? Yes No