cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andy_Prog
Level: Powered On

Hide a User in a Gallery

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Andy_Prog
Level: Powered On

Re: Hide a User in a Gallery

@lucia  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!

View solution in original post

10 REPLIES 10
Highlighted
Dual Super User
Dual Super User

Re: Hide a User in a Gallery

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?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
lucia
Level 8

Re: Hide a User in a Gallery

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
Level: Powered On

Re: Hide a User in a Gallery

@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
Level: Powered On

Re: Hide a User in a Gallery

@lucia  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
    )
)  

Dual Super User
Dual Super User

Re: Hide a User in a Gallery

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

lucia
Level 8

Re: Hide a User in a Gallery

Hey, 

 

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

 

 

Andy_Prog
Level: Powered On

Re: Hide a User in a Gallery

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!

Dual Super User
Dual Super User

Re: Hide a User in a Gallery

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
Level: Powered On

Re: Hide a User in a Gallery

@lucia  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!

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,916)