Gallery - Sort and If Statement

(2) Share

Report

Posted on by zw2348

Hello,

I'm still new to Power Apps and have been doing a lot of research to get me by. I'm stumped now, I'm currently using:

"If(Lookup.Text<>"",(Search(Routes,Lookup.Text,Title)),Routes)"

In the Items field and it works correctly. But I need to change the Sort of the that Ascending departure times. I've looked at Set and Sort/SortByColumns and they are not working well together.

TIA!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hey. If you replace this:

(Search(Routes,Lookup.Text,Title)),Routes)

With this, and change the Power Fx to match your columns, etc:

SortByColumns( Search(Routes,Lookup.Text,Title),Routes, "departuretime", SortOrder.Ascending )

Does sorting work as expected?

Was this reply helpful? Yes No
zw2348 91 on at

Like (2)

Report
Copy link

Link copied!

Keith,

Thanks for the response! I changed the formula to match my data source/items.

If(RouteLookup.Text<>"",SortByColumns(Search(OutboundRoutes,RouteLookup.Text,Title)),OutboundRoutes,"Departure Time",SortOrder.Ascending)

PA is giving me 3 issues

Unexpected Characters. The Formula contains 'Eof' where 'ParenClose' is expected.

This error occurs if, for example, a formula contains '{Val@ 7}' instead of '{Val: 7}'. When you set a variable the syntax requires a colon instead of an "at" symbol.

Invalid argument type (Table). Expecting a Text Value instead.

The function 'SortByColumns' has some invalid arguments.

Was this reply helpful? Yes No
Suggested answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Thanks for the follow-up. I think we're close! What happens if you use this Power Fx code snippet?:

If(RouteLookup.Text<>"", SortByColumns( Search(OutboundRoutes,RouteLookup.Text,Title), "Departure Time", SortOrder.Ascending )

Was this reply helpful? Yes No
zw2348 91 on at

Like (2)

Report
Copy link

Link copied!

Very close! Only returned error is the Unexpected Error

Unexpected Characters. The Formula contains 'Eof' where 'ParenClose' is expected.

This error occurs if, for example, a formula contains '{Val@ 7}' instead of '{Val: 7}'. When you set a variable the syntax requires a colon instead of an "at" symbol.

The RouteLookup is a reference to the new Text (Preview) box.

Was this reply helpful? Yes No
Suggested answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Ooh, almost there! I think I missed a bracket - does this work?

If(RouteLookup.Text<>"", SortByColumns( Search(OutboundRoutes,RouteLookup.Text,Title), "Departure Time", SortOrder.Ascending ) )

Was this reply helpful? Yes No
zw2348 91 on at

Like (1)

Report
Copy link

Link copied!

99% there.. now I don't understand why, when the text box is empty the gallery is empty as well. But it is sorted correctly. That part of the formula really didn't change..

Was this reply helpful? Yes No
Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
I think that's happening because of the first check in the If statement - if you change to this, is the behaviour different?:

SortByColumns( Search(OutboundRoutes,RouteLookup.Text,Title), "Departure Time", SortOrder.Ascending )

If any of my posts work, please mark them as the answer 😊

Was this reply helpful? Yes No
zw2348 91 on at

Like (1)

Report
Copy link

Link copied!

That's it! Thank you!

Was this reply helpful? Yes No