Sorting in descending order

(1) Share

Report

Posted on by Vedant28

hi Expert i have a gallery trying to sort

code i have

With({_items: SortByColumns(
 Filter(Opportunity, "ID",
 country= CTDDL_5.Selected.Result|| CTDDL_5.Selected.Result=Blank(),
 remediationstatus=stageDDL_5.Selected.Result||stageDDL_5.Selected.Result=Blank()
 ), "opportunityname","opportunitydescription","Title", If(SortDescending1,SortOrder.Ascending,SortOrder.Descending)
 )
 }, 
 Filter(
 _items, TextInput3_5.Text in opportunitydescription|| TextInput3_5.Text in opportunitynumber||TextInput3_5.Text in referenceid
 )
)

i want to sort the gallery based on latest id. my latest id is 49 but its random

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

developingteal 392 on at

Like (0)

Report
Copy link

Link copied!

do something like Sort(table, ID, sortorder.descending)

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Vedant28,

Thank you for providing the code snippet and screenshot! 😊

The currenct code was sorting based on multiple columns with a conditional ascending / descending value. Additionally, the text value ID was written as a Filter parameter - not as a SortByColumns parameter.

In case you only want to sort the datasource descendingly based on ID, you can use the code below:

With( { _items: Filter( Opportunity, country = CTDDL_5.Selected.Result || CTDDL_5.Selected.Result=Blank(), remediationstatus = stageDDL_5.Selected.Result || stageDDL_5.Selected.Result=Blank() ) }, Sort( Filter( _items, TextInput3_5.Text in opportunitydescription || TextInput3_5.Text in opportunitynumber ||TextInput3_5.Text in referenceid ), ID, SortOrder.Descending ) )

If this solves your question, would you be so kind as to accept it as a solution. ✔️

If you liked my solution, please give it a thumbs up. 👍

Connect with me: LinkedIn | Blog

Was this reply helpful? Yes No