Answered

Rearranging the order of gallery items so that specific value appears first

(0) Share

Report

Posted on by emfuentes27

578

I have a gallery that shows Counties for each State. The State is selected using a Radio Button, and it filters the counties for the selected State. This part works perfectly. The issue is that the data is in SharePoint, and the counties are ordered in alphabetical order, which is fine, except that there is a "All Counties" value that's always at the end. I don't want the user to scroll all the way down to be able to select the "All Counties" option. Instead, I would like to move this specific option to the very top. The counties are shown in a gallery with Wrap Count = 3.

Screenshot 2023-09-15 123644.png

Radio Button Data

Items = GroupBy(
 Filter(
 State_County,
 RO = myRO
 ),
 "State",
 "GroupedState"
)

Gallery Data

//
Items = Filter(
 State_County,
 State = Radio2.Selected.State
)
//--------
Checkbox.Text = ThisItem.County_Name

Thanks in advanced for any help.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@emfuentes27 - have you tried using Sort on that specific value?

Sort( Filter( State_County, State = Radio2.Selected.State ), State = "All Counties", SortOrder.Descending )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @emfuentes27 ,

Try this in the Items of the Radio control

Ungroup( Table( { Data: Table( {Value: "All Countries"} ) }, { Data: GroupBy( Filter( State_County, RO = myRO ), "State", "GroupedState" ) }, ), "Data" )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
emfuentes27 578 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz . Thanks for the reply, I really appreciate it, but it doesn't work. I get a few errors, including:
1. Invalid number of arguments, received 1, expected 2.
2. Function Table has some invalid arguments.
3. Cannot use non-record value in this context.
emfuentes27 578 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik . Thanks for the reply, but the change you proposed doesn't do anything, "All Counties" still at the end.
Verified answer

emfuentes27 578 on at

Like
a
(0)

Report
Copy link

Link copied!
I was able to figure it out using @RandyHayes videos. and adapting it to my needs. It is not pretty, but good enough for now:
Radio:
Items: GroupBy( Counties_States,"State", "GroupedState" ) OnSelect: ClearCollect( Cnty_Col, {County_Name: "All Counties"}, Filter( Counties_States, State = StatesRadio.Selected.State && County_Name <> "All Counties" ) )

Gallery:
Items: Cnty_Col
The biggest difference regarding the data is that I had to load all State/County data when App stars, because I was getting some Delegation warnings, and there 3000+ counties in the US, so I was hitting some limits. So I created the
Counties_States collection with all the data.
I hope this help somebody.

Thanks for the help.