cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Filtering people picker

Hi All,

 

Is there a way to filter a Office365 SharePoint people picker column. I would like to not display any people in the people picker who has an email address of @specificdomain.com 

 

Is this possible?

4 REPLIES 4
Highlighted
Super User
Super User

Re: Filtering people picker

Hm. Interesting challenge. Thanks for posting. 

 

How about an IF statement like this: 

 

  • Text box named "searchTerm"
  • Gallery named "gallery1"
  • Label in gallery1 named "emailAddy"
    • Text Property of emailAddy:
    • If(
          "@specificdomain.com" in ThisItem.Mail,
          "I'm a taco",
          ThisItem.Mail
      )

 My friends make heavy use of the "in" command. Here is a fun use!!

 

Good luck!

 

Anonymous
Not applicable

Re: Filtering people picker

Awesome, I'll try it. Any other ideas keep them coming/ 🙂

Highlighted
Super User
Super User

Re: Filtering people picker

If you're using a Combobox Control to search, you might also mess with the DisplayFields and SearchFields Properties. I bet you can set an IF statement similar to the above that will filter directly at the search Control rather than at the display Control.

 

Cheers!

Highlighted
Community Support
Community Support

Re: Filtering people picker

Hi @Anonymous,

 

Do you want to filter the Person type column of SP list within your app when you select a person from the People picker control?

 

If you want to filter out the person whose email contains '@specificdomain.com' when you select/search person within the People picker control (Combo box control), I have made a test on my side, I afraid that there is no way to achieve your needs in PowerApps currently.

 

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Kris 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,779)