double filter in a gallery

[AlexTB]

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?

[eka24]

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.

[AlexTB]

I tried 

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

Nothing appear

[eka24]

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.

[AlexTB]

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.

[AlexTB · Accepted solution]

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