cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patty789
Helper V
Helper V

Sort and Filter a dropdown

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

1 ACCEPTED SOLUTION

Accepted Solutions

@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). 

View solution in original post

4 REPLIES 4
mdevaney
Super User
Super User

@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."

@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). 

@patty789 

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

ejberrio
New Member

Hi.

This simple solution works for me:

Sort(Sharepoint data source, Column name, Ascending/Descending)

 

Thanks.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,436)