cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Multiple checkbox

Good morning,

I hope someone can help me. I would like both checkboxes (PC and laptop) to filter the data. So if I check PC then a filter has to be done on "Computer type", this can have the value PC or laptop.

I hope someone can help me.

 
9 REPLIES 9
Highlighted
Community Champion
Community Champion

Re: Multiple checkbox

Follow these steps:

 

CheckBox1

OnCheck

Collect(ColStatus,"PC")

 

OnUnCheck

Remove( ColStatus,First( Filter( ColStatus, Value="PC" ) ) )

 

CheckBox2

OnCheck

Collect(ColStatus,"Laptop")

 

OnUnCheck

Remove( ColStatus,First( Filter( ColStatus, Value="Laptop" ) ) )

 

Filter:

Filter(TableName, 'Computer type' in ColStatus)

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

Highlighted
Helper I
Helper I

Re: Multiple checkbox

 eka24,

 

Where do I place the filter? 

 

Regards

Raymond

 

 

Highlighted
Community Champion
Community Champion

Re: Multiple checkbox

Put the formula on the ITEMS of the Gallery. That is replace the Existing Gallery Items with the filter formula

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper I
Helper I

Re: Multiple checkbox


Good afternoon,
It seems to do something indeed. Thank you very much for this. Unfortunately unfortunately not quite right yet. When I check the laptop, a PC occasionally comes in between. Is there still a solution for this? I also get an exclamation mark at the filter. Is this perhaps the problem?
My old rule was
SortByColumns (Search ([@ '[dbo]. [Day plan]'], TextSearchBox1.Text, "AssettTag", "BCNReference", "BCNReservationID"), "AssettTag", If (SortDescending1, Descending, Ascending))

How can I combine it with the new line 'filter ....'?
Thank you very much in advance
Raymond
Highlighted
Community Champion
Community Champion

Re: Multiple checkbox

Can you give a screenhot of the formula i gave on the GALLERY:

Please show the Gallery items formula if it is not working for me to see the errors

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper I
Helper I

Re: Multiple checkbox

This one?

Highlighted
Community Champion
Community Champion

Re: Multiple checkbox

Please revise the Filter to:

Filter(TableName, 'Computer type' in ColStatus.Value)

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper I
Helper I

Re: Multiple checkbox

Hi,

Is it possible. the checkbox is default on? I mean not the default is true but the same action as onclick 

 

regards

 

Highlighted
Helper I
Helper I

Re: Multiple checkbox

Sorry

 

Mean oncheck not onclick 

 

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,439)