Filter using Contains

[Taylope1]

Hi ,

So here is my items filter line.

SortByColumns(Filter([@'SAM Catalogue'], 'BU Approved'.Value="AAA", TextSearchBox1.Text in Description||TextSearchBox1.Text in Application),"Title", If(SortDescending1, Descending, Ascending))

Works fine.   Now I want to add something like If(Office365Users.MyProfile().UserPrincipalName contains "XYZ" to the beginning so if my domain (which is contained in UserPricipalName) has XYZ in it the filter above will be applied.

Driving me mad!!

[eka24 · Accepted solution]

Try
SortByColumns( If("XYZ" in Office365Users.MyProfile().UserPrincipalName , Filter([@'SAM Catalogue'], 'BU Approved'.Value="AAA", TextSearchBox1.Text in Description||TextSearchBox1.Text in Application)),"Title", If(SortDescending1, Descending, Ascending))

Or

If(IsMatch(Office365Users.MyProfile().UserPrincipalName,"xyz",Contains),
SortByColumns( If("XYZ" in Office365Users.MyProfile().UserPrincipalName , Filter([@'SAM Catalogue'],
'BU Approved'.Value="AAA", TextSearchBox1.Text in Description||TextSearchBox1.Text in Application)),
"Title", If(SortDescending1, Descending, Ascending))

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

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.