Hide a User in a Gallery

[Andy_Prog]

Hey guys!

I have a gallery reading Office365 Users, but there's one user I don't want to be in the Gallery.

Is there any function in particular that would work for this?

I have tried so many methods to hide just one user.

Thank you.

[Pstork1]

What is the items setting for the gallery?  Couldn't you just add an additional Filter() function around that to Filter out that one user?

[Anonymous]

Hey,

When setting items in a galerry, u can use Filter() and as condition to be Not(user_u_donot_want_to_display in column).

So for example, if you know the email of the user u can use Filter(Datasource, Not(user_email in WorkEmail_field))

Hope this helps.

[Andy_Prog]

@Pstork1 So far I have this in the Items:

Filter(
    Office365Users.SearchUser(
        {
            searchTerm: txtInputEmployee.Text,
            top: 500
        }
    ),
    AccountEnabled = true,
    If(
        Len(Department) < 1,
        Department = ddDepartment.Selected.Value,
        true
    ),
    If(
        ddDepartment.Selected.Value <> "",
        Department = ddDepartment.Selected.Value,
        true
    ),
        If(
        Len(Mail) > 1,
        true
    )
)

[Andy_Prog]

@Anonymous  So far I have this code in the Items, where would I place the code you gave me?

Filter(
    Office365Users.SearchUser(
        {
            searchTerm: txtInputEmployee.Text,
            top: 500
        }
    ),
    AccountEnabled = true,
    If(
        Len(Department) < 1,
        Department = ddDepartment.Selected.Value,
        true
    ),
    If(
        ddDepartment.Selected.Value <> "",
        Department = ddDepartment.Selected.Value,
        true
    ),
        If(
        Len(Mail) > 1,
        true
    )
)  

@ 

[RezaDorrani]

Hi @Andy_Prog 

Add UserPrincipalName<>"the user email" to your filter criteria

Regards,

Reza Dorrani

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

[Anonymous]

Hey, 

just put comma in your filter function and add the desirable condition.

[Andy_Prog]

Hey @RezaDorrani,

I'm a little new to PowerApps, still learning. Here I provide my code I have so far, where would I place your code?

Filter(
    Office365Users.SearchUser(
        {
            searchTerm: txtInputEmployee.Text,
            top: 500
        }
    ),
    AccountEnabled = true,
    If(
        Len(Department) < 1,
        Department = ddDepartment.Selected.Value,
        true
    ),
    If(
        ddDepartment.Selected.Value <> "",
        Department = ddDepartment.Selected.Value,
        true
    ),
        If(
        Len(Mail) > 1,
        true
    )
)

Thank you!

[RezaDorrani]

Hi @Andy_Prog 

Filter(
    Office365Users.SearchUser(
        {
            searchTerm: txtInputEmployee.Text,
            top: 500
        }
    ),
    AccountEnabled = true,
UserPrincipalName <> "enter the email here".
    If(
        Len(Department) < 1,
        Department = ddDepartment.Selected.Value,
        true
    ),
    If(
        ddDepartment.Selected.Value <> "",
        Department = ddDepartment.Selected.Value,
        true
    ),
        If(
        Len(Mail) > 1,
        true
    )
)

[Andy_Prog · Accepted solution]

@Anonymous  Thank you so much!

I changed the Email to DisplayName and it worked!

Filter(
    Office365Users.SearchUser(
        {
            searchTerm: txtInputEmployee.Text,
            top: 500
        }
    ),
    Not("Display Name" in DisplayName),
    AccountEnabled = true,
)

I appreciate it thank you very much!