cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chris_young
Helper III
Helper III

Filter Person or Group field in Form

Hello all, 

 

I have a SharePoint list. In this list I have the field Approver. This field is a Person or Group field which pulls from AD. A person should be able to select anyone in this list except themselves. 

 

This is the base Items: Choices([@'Procurement Request'].VPApprover)

 

I have tried many variations of something like this:

Filter(Choices([@'Procurement Request'].VPApprover),DisplayName <> User().FullName)

Filter(Choices([@'Procurement Request'].VPApprover),ThisItem.'VP Approver'.Email <> User().Email)

 

I just can't find the right combo to make it work. Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
VijayTailor
Resident Rockstar
Resident Rockstar

Hi @chris_young ,

You can tey with the below Code Approach.

Filter(Choices([@'Procurement Request'].VPApprover),Lower(DisplayName) <> Lower(User().FullName))

Filter(Choices([@'Procurement Request'].VPApprover),Lower(ThisItem.'VP Approver'.Email) <> LOwer(User().Email))

 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Please Vote for my idea if you feel, that will help you in the future or good to have in power app.
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Ability-s-to-Select-Icon-from-UIFabric/idi-p/69...

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Preview-Mode-for-All-the-Device-Like-Phone-Tabl...

 

View solution in original post

2 REPLIES 2
VijayTailor
Resident Rockstar
Resident Rockstar

Hi @chris_young ,

You can tey with the below Code Approach.

Filter(Choices([@'Procurement Request'].VPApprover),Lower(DisplayName) <> Lower(User().FullName))

Filter(Choices([@'Procurement Request'].VPApprover),Lower(ThisItem.'VP Approver'.Email) <> LOwer(User().Email))

 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Please Vote for my idea if you feel, that will help you in the future or good to have in power app.
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Ability-s-to-Select-Icon-from-UIFabric/idi-p/69...

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Preview-Mode-for-All-the-Device-Like-Phone-Tabl...

 

@VijayTailor 

Bingo!!! Thank you

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,280)