Answered

Filtering using check boxes and multiple option choice fields

(0) Share

Report

Posted on by PeterBayliss

Hello,

I am trying to filter a gallery using check boxes and I am hitting a wall. I figure there is an easy way to do this, but i have been staring at it four hours.

The idea is that when the check box is selected, only items that have "Pending Approval" will be displayed. Unchecked will show all items. I plan to have separate check boxes to filter for each of the options specified below.

Filter(
 ProjectList,
 If('RTO Pending Approval 2.1'.Value=true,'Ready to Order'.Value="Pending Approval",'Ready to Order'.Value<>""),

Projectlist is a collection created from a SharePoint Online list at the launch of the app.

'RTO Pending Approval 2.1' is a check box on a screen in Power Apps.

'Ready to Order' is a multiple choice field.

Pending Approval
Pending Approval, New Games Ordered
Approved - Ready To Order
New Games Ordered
Conversions Ordered
N/A

"Pending Approval" is the string I am searching for.

I hope someone out there can help me with this. Thank you in advance.

Peter.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @PeterBayliss ,
You can put the If inside the filter, but I have had issues with it at times.
The below should work.
If( 'RTO Pending Approval 2.1'.Value=true, Filter( ProjectList, 'Ready to Order'.Value="Pending Approval" ), Filter( ProjectList, 'Ready to Order'.Value<>"") ) )

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.

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @PeterBayliss ,
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.

Was this reply helpful? Yes No
PeterBayliss 13 on at

Like (0)

Report
Copy link

Link copied!

Hello @WarrenBelz

The answer you provided worked perfectly. You have no idea how much I appreciate your assistance.

Thank you so much
Peter.

Was this reply helpful? Yes No