cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andy_Prog
Resolver I
Resolver I

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

@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
Pstork1
Dual Super User III
Dual Super User III

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
Resolver II
Resolver II

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.

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

 

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

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

Hey, 

 

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

 

 

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!

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

@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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,586)