filter gallery with checkbox

(0) Share

Report

Posted on by AshishJaiswal

776

Hello Experts,

I would like to filter my gallery with current user if they click on a check box

Currently I am using this code

SortByColumns(
 Filter(
 'DWP Exceptions Tracker',
 Or(
 StartsWith('Customer Name',InputSearchID.Text),
 ID = Value(InputSearchID.Text),
 StartsWith('Title of Exception',InputSearchID.Text)
 )
 ),
 "Created",
 Descending
)

I tried using IF function but it doesn't seems to work, please guide me

Here is what i was trying

If(Checkbox2.Value = false,
SortByColumns(
 Filter(
 'DWP Exceptions Tracker',
 Or(
 StartsWith('Customer Name',InputSearchID_1.Text),
 ID = Value(InputSearchID_1.Text),
 StartsWith('Title of Exception',InputSearchID_1.Text)
 )
 ),
 "Created",
 Descending
),SortByColumns(
 Filter(
 'DWP Exceptions Tracker',
 Or(
 StartsWith('Customer Name',InputSearchID_1.Text),
 ID = Value(InputSearchID_1.Text),
 StartsWith('Title of Exception',InputSearchID_1.Text),'Created By'.Email = User().Email
 )
 ),
 "Created",
 Descending
))

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AshishJaiswal ,

Try this

Sort( Filter( 'DWP Exceptions Tracker', ( StartsWith( 'Customer Name', InputSearchID_1.Text ) || ID = Value(InputSearchID_1.Text) || StartsWith( 'Title of Exception', InputSearchID_1.Text ) ) && ( !Checkbox2.Value || 'Created By'.Email = User().Email ) ), Created, Descending )

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.

Visit my blog Practical Power Apps
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AshishJaiswal ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps
AshishJaiswal 776 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz

Only Checkbox work

other then that search with customer name column, Title of Request column and ID column does not work
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AshishJaiswal ,

The code is valid providing the and/or bracketing is what you need - please check this.