web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Checkbox Filter on Sin...

Power Apps

Answered

Checkbox Filter on Single line of text column

(0) Share

Report

Report

Posted on by AshishJaiswal

776

Could someone please guide me how to filter using checkbox with single line of text as column,

I have columns with names Admin impact, Feature Update, Major Update etc. My sharepoint list item will have entry like below

Lets say, If I plan to include checkbox filter

Checkbox for 'featureupdate' and 'Admin impact' etc, if user clicks on the checkbox gallery should filter based on the checkbox selection.

Please guide me

Hello Experts,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Here is an example.

In this example my SPList is Named StorageUnits

I have 2 checkboxes, checkbox1 and checkbox2.

Checkbox1 has text property of one of the possible strings found in the ContactName column of my splist

Checkbox2 has text property of one of the possible strings found in the ContactDepartment column of my splist.

The gallery below them has a Items property of

If( And(Checkbox1.Value=true,Checkbox2.Value=true), Filter(StorageUnits, ContactName=Checkbox1.Text || ContactDepartment=Checkbox2.Text), And(Checkbox1.Value=true,Checkbox2.Value=false), Filter(StorageUnits, ContactName=Checkbox1.Text), And(Checkbox1.Value=false,Checkbox2.Value=true), Filter(StorageUnits, ContactDepartment=Checkbox2.Text), StorageUnits )

This gives me all gallery items when nothing checked, only items matching either checkbox if only one is selected, and all items that match one of the two when both are selected (can change that to only items that have BOTH selected by changing the || to &&)

Was this reply helpful? Yes No

Join the conversation