Answered

"SortOrder.Descending" syntax error in my formula

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

WarrenBelz 156,007 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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})

Was this reply helpful? Yes No
WarrenBelz 156,007 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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 156,007 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thanks a lot ! It works...

Was this reply helpful? Yes No
sid95 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No