Answered

Filter the Choice of a People picker column keeping it searchable

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

Could anyone help me with this?

I have used a people column from a SharePoint list to give myself a combo box where people and groups can be selected. This was the only way I could find of getting a combo box that allowed the selection of both users and groups/distributions lists. It works well and I then submit the addresses picked from the box into Power Automate to start a different process not into the list the combo box is using as its data source.

However, this now shows ALL groups including a display name for "Everyone except external users" (this doesn't email as it has no address attached to it) but I want to hide it to avoid causing concern to people. There are a number of other groups I could do with hiding as well.

So to the combo box, I added this code:

Filter(Choices([@'NGHelp-Test Distribution List'].People), Not(DisplayName = "Everyone except external users"))

Which works BUT it kills the searchability of the box. If I reset IsSearchable to true all it will now do is search the initial 15 options that dropdown.

To be clearer when the combo box code is just:

Choices([@'NGHelp-Test Distribution List'].People)

I can search the box and find any person or list in the whole directory:

But when I set the code to:

Filter(Choices([@'NGHelp-Test Distribution List'].People), Not(DisplayName = "Everyone except external users"))

The same search produces 0 results:

And the search will only work for things in the 1st 15 records, the records that show when no search term is entered:

Does anyone know how I can make this work/an effective way of filtering a "Choices" combo box without destroying it's searchability?

I have also tried:

Filter(
 Choices([@'NGHelp-Test Distribution List'].People),
 !IsMatch(DisplayName,
 "Everyone except external users", Contains & IgnoreCase))

Which produces similar behavior.

Thanks in advance.,

David

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to remove the "Everyone except external users" group from your dropdown list?

Actually, there is no directly way to achieve this in Power Apps currently.

As an alternative solution, I think you could use the PowerShell to achieve this.

SharePoint Online does NOT enforce licensing requirements, everyone in the organization will be able to access pages (depending on the permissions of course). You can remove the "everyone except external users" claim by running the following PowerShell cmdlet:

Set-SPOTenant -ShowEveryoneExceptExternalUsersClaim:$false

More details, please check as below:

Set-SPOTenant (SharePointOnlinePowerShell) | Microsoft Docs

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

Thanks very much for this.

I don't want to remove it that way because we use it at other places in our SharePoint environment. All I wanted to do was hide it from the dropdown so it didn't cause any end-users concern thinking people could use it to email all members of staff (something we have very strict policies about).

And as outlined above I found a way to hide it but it messes up the rest of the functionality of the combo box but if you're saying there is no way to hide it and keep the functionality of the combo box intact then I guess I will just list with it.

Thanks,
David

Was this reply helpful? Yes No