cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
billyapps
Level: Powered On

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
Fatih1
Level: Powered On

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
Fatih1
Level: Powered On

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

billyapps
Level: Powered On

Re: Filtering in nested galleries

Thank you! Worked a treat 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (7,108)