Sort and Filter a dropdown

(0) Share

Report

Posted on by patty789

250

Hi,

I have been stuck on this i have a dropdown that is reading from a SharePoint list, but is not in alphabetical order. Currently i have a filter in place that is only showing the Request using the formula: Filter(SP data source, "Request" in Lower('Type of Request')) when i add the Sort i don't get the result i need. Sort(Filter(SP data source, "Request" in Lower('Type of Request')).'Item Line', Ascending)

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

mdevaney 29,989 Moderator on at

Like (1)

Report
@patty789

A couple of issues here. The "sort by" field is missing and one bracket was in the wrong place. See my code below.

Sort( Filter( SP data source, "Request" in Lower('Type of Request')).'Item Line', ), 'Item Line', Ascending )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

patty789 250 on at

Like (1)

Report

@mdevaney Thank you for you help, yet i kept getting an error, what worked for me was this. Sort(Filter(SP data sorce, "Request" in lower('Type Request')). 'Item Line', 'Item Line', Ascending).

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@patty789

If your question was solved please mark as solution and close the thread. I've corrected my syntax above.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

Hi.
This simple solution works for me:
Sort(Sharepoint data source, Column name, Ascending/Descending)

Thanks.

Was this reply helpful? Yes No
dmclaughlin 347 on at

Like (0)

Report

Sort(Filter('Livingston Presses', "Press-Heater-Plate"="P").'Press', 'Press', SortOrder.Ascending)
I used this syntax in a dropdown on a power app and my issue is the values do not show.
Distinct(Filter('Livingston Presses','Press-Heater-Plate'="P"),Press)
If I use this syntax in the drop down I get my values but they are not sorted.
Help?

Was this reply helpful? Yes No