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

double filter in a gallery

Dears,

I have created a gallery of tasks for different teams with a filter based on owner for task not yet completed

Final formula (that works) is

Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata"))

Now, the same board is used by different team and I would like to add an additional condition with the filter that will also check the content of the dropbox field "Team"

The dataset is in sharepoint

I tried the folowing: 

Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata") & Filter('PR&C Accountability Board', TextInput2.Text in Team)

but does not works. Can you help me?

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

Re: double filter in a gallery

Navigating and trying.... success again.

I have created a Dropdown box with the formula 

["Tier 1 Complaint","Tier 1 Release","Tier 2"]

Than into my gallery I have changed my formula as following

Filter('PR&C Accountability Board', (Dropdown1.Selected.Value in Team.Value) && TextInput1.Text in Owner &&Not(Status.Value="Completata"))

and... WORKS PERFECTLY!

I'm really proud

View solution in original post

5 REPLIES 5
Highlighted
Community Champion
Community Champion

Re: double filter in a gallery

Try

Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata")&&

TextInput1.Text in Owner)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Frequent Visitor

Re: double filter in a gallery

I tried 

Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata") && TextInput2.Text in Team)

Nothing appear

Highlighted
Community Champion
Community Champion

Re: double filter in a gallery

The And && Formula will return values where all conditions are met. Have you entered anything in the 2 textboxes. You can also replace && with Or.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Frequent Visitor

Re: double filter in a gallery

I tried the following:

Filter('PR&C Accountability Board'; TextInput1.Text in Owner &&Not(Status.Value="Completata") or TextInput2.Text in Team)

and

Filter('PR&C Accountability Board'; TextInput1.Text in Owner &&Not(Status.Value="Completata")) && Filter('PR&C Accountability Board'; TextInput2.Text in Team(Status.Value=""))

does not works.

 

Frequent Visitor

Re: double filter in a gallery

Navigating and trying.... success again.

I have created a Dropdown box with the formula 

["Tier 1 Complaint","Tier 1 Release","Tier 2"]

Than into my gallery I have changed my formula as following

Filter('PR&C Accountability Board', (Dropdown1.Selected.Value in Team.Value) && TextInput1.Text in Owner &&Not(Status.Value="Completata"))

and... WORKS PERFECTLY!

I'm really proud

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

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,341)