Conditional Filter for Gallery based on drop down responses

(0) Share

Report

Posted on by mcnemare1

214

Hello,

I have a SharePoint list containing products available for each of these test branches as follows:

[Status], [Branch], [Biz_Pers],[Product_Type],[Product], [URL]

I want the gallery to filter based on the user's selections of each consecutive drop down, but right now its blank, I feel my formula is right (attached below)

any help would be appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @mcnemare1 ,

Try this structure and see if it works for you. Also please remember to post your code in Text - the below is OCR'd so watch spelling

Filter( 'PURL_LINKS_BETA-fbccd597-30be-4015-a0cl-53a998f29b39', ( Len(BusinessOrPersonalDropDown.Selected.Value) = 0 || Biz_Pers.Value = BusinessOrPersonalDropDown.Selected.Value ) && ( Len(BranchDropDown.Selected.Value) = 0 || Branch.Value = BranchDropDown.Selected.Value ) && ( Len(ProductTypeDropdown.Selected.Value) = 0 || Product_Type.Value = ProductTypeDropdown.Selected.Value ) && ( Len(ProductDropdown.Selected.Value) = 0 || Product.Value = ProductDropdown.Selected.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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @mcnemare1,

The last dropdown you are checking 'Product Dropdown', you have swapped the Or with a comma.
Could you try ProductDropdown.Selected.Value = Blank() Or Product.Value = ProductDropdown.Selected.Value

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
mcnemare1 214 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Both Solutions work!

Was this reply helpful? Yes No
mcnemare1 214 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you both Solutions Work!

Was this reply helpful? Yes No