Answered

sort by date range

(0) Share

Report

Posted on by Matt383

407

Hi, Just added a sort icon into the gallery to filter by recent date. The Onselect of the icon has UpdateContext({SortDescending1:true})

and in the items of the gallery i currently have,

Filter(KBLCollection,StartsWith(Title,Srchbox.Text) && (Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted",Submitted,!Submitted)))

I thought i could put in something like this,

Filter(KBLCollection,StartsWith(Title,Srchbox.Text) && (Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted",Submitted,!Submitted))),"Date" , If(SortDescending1, Descending, Ascending))

but no luck, can you please assist

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Matt383 ,

You had an extra closing bracket in there

Filter( KBLCollection, StartsWith( Title, Srchbox.Text ) && ( Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted", Submitted, !Submitted ) ), "Date", If( SortDescending1, Descending, Ascending ) )

You could also toggle the sort with

UpdateContext({SortDescending1:!SortDescending1})

I am assuming here Submitted is a Boolean (yes/no) field.

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
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren, thanks for your reply. It no longer brings any errors, however now nothing shows in the gallery

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

before and after

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Matt383 ,

Dangers of free-typing - you left out Sort

Sort( Filter( KBLCollection, StartsWith( Title, Srchbox.Text ) && ( Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted", Submitted, !Submitted ) ) ), Date, If( SortDescending1, Descending, Ascending ) )

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
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Thanks Warren, Gallery showing up now, no errors. however when i select the sort icon, nothing changes. The date fields in the gallery remain randomly throughout. I checked the onselect of the icon
UpdateContext({SortDescending1:true})
and the onselect of the gallery is
Sort( Filter( KBLCollection, StartsWith( Title, Srchbox.Text ) && ( Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted", Submitted, !Submitted ))), "Date", If(SortDescending1, Descending, Ascending ))
Also when i select the sort icon, the blue box stays there (image below)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,447 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Matt383 ,

Also forgot to take the quotes off "Date" - now fixed.

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Thanks Warren, thats the one. All sorted now. Cheers

Was this reply helpful? Yes No