cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Filtering in nested galleries

I have created a nested gallery, and want each of the vertical galleries to be filtered by a different characteristic. 

e.g. The gallery labeled 'receieved' [with value 1] to filter by received data, The gallery labeled 'investigate' will show investigated data.

 

The below code is working for one, but I need to extend it across the others

If(ThisItem.Value=1,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Received"))

 

In my mind, this should look like this and work, but it doesn't. 

If(ThisItem.Value=1,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Received",
If(ThisItem.Value=2,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Investigate",
If(ThisItem.Value=3,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Respond"))))))

(Screenshot below - greyed out for sensitive info)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Filtering in nested galleries

If(ThisItem.Value=1,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Received"),
If(ThisItem.Value=2,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Investigate"),
If(ThisItem.Value=3,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Respond"))))

 Try this out

View solution in original post

2 REPLIES 2
Highlighted
Helper III
Helper III

Re: Filtering in nested galleries

If(ThisItem.Value=1,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Received"),
If(ThisItem.Value=2,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Investigate"),
If(ThisItem.Value=3,Filter(TABLE_MASTER_DATABASE,'$ Phase'="Respond"))))

 Try this out

View solution in original post

Highlighted
Frequent Visitor

Re: Filtering in nested galleries

Thank you! Worked a treat 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

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 (10,604)