Help with filter with "and" and "or"

[almecum]

Hi

I need help on how to correct this code. The below filter works for the second clause if the checkbox is not closed. I need the same for the first part when the checkbox is checked. 

Maybe this is not the correct way to do it. 

Ask: I need to show only data where the status <> closed and when the checkbox is checked then only for a spacific user. I was doing it using a filter but maybe there is a simpler way of doing it.

Thanks

If(Checkbox1.Value = true,SortByColumns(Filter('X-Dependency Tracker 1.0 v1', StartsWith('Dependency Owner'.DisplayName, CurrentUser.FullName)|| StartsWith(Requestor.DisplayName, CurrentUser.FullName)), "Title", If(SortDescending1, Descending, Ascending)),SortByColumns(Filter('X-Dependency Tracker 1.0 v1', StartsWith('Dependency Owner'.DisplayName, FilterTextBox.Text) && 'State'.Value <> "Closed"), "Title", If(SortDescending1, Descending, Ascending)))

[RezaDorrani · Accepted solution]

Hi @almecum 

Try

If(Checkbox1.Value,SortByColumns(Filter('X-Dependency Tracker 1.0 v1', (StartsWith('Dependency Owner'.DisplayName, CurrentUser.FullName)|| StartsWith(Requestor.DisplayName, CurrentUser.FullName)) && 'State'.Value <> "Closed"), "Title", If(SortDescending1, Descending, Ascending)),SortByColumns(Filter('X-Dependency Tracker 1.0 v1', StartsWith('Dependency Owner'.DisplayName, FilterTextBox.Text) && 'State'.Value <> "Closed"), "Title", If(SortDescending1, Descending, Ascending)))

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Jeff_Thorpe]

Have you tested to make sure 'Dependency Owner'.DisplayName has the exact name as CurrentUser.FullName? I ask because User().FullName and SPOPersonField.Name doesn't return the exact same name for me in my tenant. 

If that ends up being the issue you could try using the email address.

StartsWith('Dependency Owner'.Email, CurrentUser.Email)

StartsWith(Requestor.Email = CurrentUser.Email)

[almecum]

Hi

I did set a variable on app start to set CurrentUser from User() so it is working for me. I used text boxes to check the value they both returned, and so far its all working. I am also using People fields in SharePoint for DependencyOwner and Requestor.