Answered

"SortOrder.Descending" syntax error in my formula

(0) Share

Report

Posted on by Community Power Pla...

Hello,
I have some difficulties when I write this formula in my "Browse screen" screen, I would just like to use the SORTBYCOLUMNS function, with SORTORDER.DESCENDING. Because in fact I want my files to appear from the most recent to the oldest. But I can’t find the right writing syntax...
My current formula is:

************************************************************************************************

SortByColumns(Filter(MY SHAREPOINT LIST;Agence.Value = Dropdown2.SelectedText.Value; Or(
StartsWith(Commune;TextSearchBox1_1.Text);
StartsWith(Enquêteur;TextSearchBox1_1.Text);
StartsWith(Text(ID);TextSearchBox1_1.Text);
StartsWith(Text('Nom de la voie');TextSearchBox1_1.Text);
StartsWith(Text('Nom du demandeur du contrôle');TextSearchBox1_1.Text);
StartsWith('Code INSEE Commune'&"-"&(ID);TextSearchBox1_1.Text);
StartsWith('Numéro de voie';TextSearchBox1_1.Text)));"ID";
If(SortDescending1;Descending;Ascending))

************************************************************************************************

And i try this formula, but it doesn't work....

************************************************************************************************

Have you any suggestions please ?

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

You have two sort parameters - you only need one

SortByColumns( Filter( MY SHAREPOINT LIST; Agence.Value = Dropdown2.SelectedText.Value && ( StartsWith(Commune;TextSearchBox1_1.Text) || StartsWith(Enquêteur;TextSearchBox1_1.Text) || StartsWith(Text(ID);TextSearchBox1_1.Text) || StartsWith(Text('Nom de la voie');TextSearchBox1_1.Text) || StartsWith(Text('Nom du demandeur du contrôle');TextSearchBox1_1.Text) || StartsWith('Code INSEE Commune'&"-"&(ID);TextSearchBox1_1.Text) || StartsWith('Numéro de voie';TextSearchBox1_1.Text) ) ); "ID"; Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report

Thanks for your proposition,
but if i write your formula,
i don't have this text :
If(SortDescending1;Descending;Ascending))

so the BUTTON "SortDescending1" like in the picture doesn't work.
This is the ON SELECT formula for this button :
UpdateContext({SortDescending1: !SortDescending1})

bouttonPOWERAPPS.PNG

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

Yes, but your original code will sort by ID descending (which is what you asked for) when you push the button (and back ascending when you push it again).

What exactly are you trying to achieve?

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

Like (0)

Report

@WarrenBelz

Thank you for your answer,
in fact, I wish that by default on the BROWSECREEN my files appear in a DESCENDING way, from the most recent to the oldest, but I also want that when we click on the button, we can still change the order in ASCENDING or DESCEDING and vice versa

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
@Anonymous ,

Just reverse the logic on the button (although you might also want to rename the Variable to SortAscending to avoid confusion)

SortByColumns( Filter( MY SHAREPOINT LIST; Agence.Value = Dropdown2.SelectedText.Value && ( StartsWith(Commune;TextSearchBox1_1.Text) || StartsWith(Enquêteur;TextSearchBox1_1.Text) || StartsWith(Text(ID);TextSearchBox1_1.Text) || StartsWith(Text('Nom de la voie');TextSearchBox1_1.Text) || StartsWith(Text('Nom du demandeur du contrôle');TextSearchBox1_1.Text) || StartsWith('Code INSEE Commune'&"-"&(ID);TextSearchBox1_1.Text) || StartsWith('Numéro de voie';TextSearchBox1_1.Text) ) ); "ID"; If( SortDescending1; Ascending; Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report

@WarrenBelz thanks a lot ! It works...

Was this reply helpful? Yes No
sid95 2 on at

Like (0)

Report

SortByColumns('Floor Opening',OpeningNumber_Column1,SortOrder.Descending);

i'm getting an error here, someone assist me please

Was this reply helpful? Yes No