How to combine Filter code and textbox

[Ben-00-38]

Hello, i can't write the correct code, can you help me?

I have a TextSearchBox and a Gallery.

The code of the gallery according to the two columns:

Depending on the items of two columns (one or the other) the rows are displayed in a Gallery.

Filter ('Customer account'; 'ATC_name (ATC)'. Email = varUser.Email || Sales Manager.Email = varUser.Email)

The gallery code for the TextSearchBox:

Filter ('Customer account'; TextSearchBox_2.Text in 'City (VIF_ADD)' || TextSearchBox_2.Text in 'Name (NM1_ADD)' || TextSearchBox_2.Text in Title)

How do you write the combination of the two codes so that the gallery displays only the values of the Filter code ('Client account'; 'ATC_name (ATC)'. Email = varUser.Email || ChefVente.Email = varUser.Email) and that I can filter with TextSearchBox?

[Drrickryp · Accepted solution]

Bon Jour @Ben-00-38 

With(
     {acct:Filter(
                  'Customer account'; 'ATC_name (ATC)'. Email = varUser.Email || 
                                       Sales Manager.Email = varUser.Email
            )
      },
      Filter(acct; TextSearchBox_2.Text in 'City (VIF_ADD)' || 
                   TextSearchBox_2.Text in 'Name (NM1_ADD)' || 
                   TextSearchBox_2.Text in Title
      )
)

Or 

With(
     {acct:Filter(
                  'Customer account'; 'ATC_name (ATC)'. Email = varUser.Email || 
                                       Sales Manager.Email = varUser.Email
            ), 
       City:'City (VIF_ADD)',
       Nom: 'Name (NM1_ADD)'
      },
    Search(
        acct,
        TextSearchBox2.Text,
        "Title",
        "City",
        "Nom"
    )
)

[RandyHayes]

@Ben-00-38 

Please consider changing your Formula to the following:

Filter ('Customer account'; 
    ('ATC_name (ATC)'. Email = varUser.Email || Sales Manager.Email = varUser.Email) &&
    (
       TextSearchBox_2.Text in 'City (VIF_ADD)' || 
       TextSearchBox_2.Text in 'Name (NM1_ADD)' || 
       TextSearchBox_2.Text in Title
    )
)

I hope this is helpful for you.