cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Filter checked boxes on toggle

I have a toggle called toggle2 outside of the gallery inside the gallery for items this is my filter Filter(
collCCBMasterData,
If(
IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = "All",
true,
'Functional Area' in ComboBox1.SelectedItems
) && If(
IsBlank(ComboBox1_1.Selected.Result) || ComboBox1_1.Selected.Result = "All",
true,
'Backlog Status' in ComboBox1_1.SelectedItems
) && If(
IsBlank(Filter.Text),
true,
Filter.Text in 'Requirement Source'
) && If(
IsBlank(Search_.Text),
true,
Search_.Text in Name
)
). I also have a checkbox inside the gallery. When the toggle is hit, I only want the checked boxes to be shown in the gallery. Is there a way I can do this?

13 REPLIES 13

Hi @powerapps890 ,

 

Do you mean you want to remove the toggle, and want the checked boxes appear at the top of gallery after the boxes are checked?

Could you please modify the Gallery.Items property as follows?

Sort(
Filter(
collCCBMasterData,
If(
IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = "All",
true,
'Functional Area' in ComboBox1.SelectedItems
) && If(
IsBlank(ComboBox1_1.Selected.Result) || ComboBox1_1.Selected.Result = "All",
true,
'Backlog Status' in ComboBox1_1.SelectedItems
) && If(
IsBlank(Filter.Text),
true,
Filter.Text in 'Requirement Source'
) && If(
IsBlank(Search_.Text),
true,
Search_.Text in Name
)
)
,CheckboxColumn,Descending)

Sik

View solution in original post

Yes, this will work. The toggle was only putting new records to the top. Is it possible to have it filter to the top with the toggle. The way you gave works, but just not for responses that the user has previously submitted. @v-siky-msft 

Hi @powerapps890 ,

 

The feature to move the checked to the top is based on the Sort function to sort the gallery items by checboxcolumn value.

Please share the checboxcolumn values of new records and previous records to see what is the difference there.

Sik

@v-siky-msft  I just realized this also doesnt work.. How do I bind the position of the checkboxes when they are at the top. It is the same issue with a toggle. When I go back into the app the checkboxes are no longer at the top @v-siky-msft 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,077)