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.
Solved! Go to 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!
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?
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 ) )
@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 ) )
@
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 ) )
@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!