Announcements
Hi All,
I have a People picker with a Mulit-select option when I would like to pass the data in the combo box dropdown option.
Here is the code I have Choices('List Name'. Requestor) but this give me the claims option (i:0#.f|membershipt|joh@contros.com) instead of email address (joh@contros.com)
Please let me know
Hi @abeyenen72 , Make sure that Layout setting of combo box is like below:
-----------------------------------------------------------------------------------------------------------------------------I hope this helps.Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍Thanks,ANB
Thanks again, but its showing everyone in AD instead of the users in the list
@abeyenen72 : Where you have written this code Choices('List Name'. Requestor) ? On items property of combo box? I didn't understand about your requirement.
Please elaborate.
Thanks,
ANB
Yes item property, when I click the dropdown it shows everyone is AD groups. Just wanted to get the users in the list
@abeyenen72 Apologies! But what do you mean by "Just wanted to get the users in the list". Requestor is people picker column in your SP and it will show you all users from AD/O365 and then you need to search the user and select accordingly. You need to make sure that you turn on the IsSearchable to true.
Yea, i don't want users from AD to show up only the users from Request columns
@abeyenen72But that is default behavior of People or groups type of column. The “Person or Group” column in SharePoint Online is used to get user or group value. This field can be configured to accept any value from the authentication provider, such as the Active directory, or can be restricted to fetch individuals from a particular SharePoint group. Users can be located either by their name or e-mail address. It also auto-fills the appropriate matching names from the available values as you type. Follow these steps to add the people picker column to the list.
If you want to restrict to any group then you need to toggle it group and select the group
#Read more: https://www.sharepointdiary.com/2016/08/sharepoint-online-add-person-or-group-column-to-list-using-powershell.html#ixzz8NhBkg3CS
Hi @abeyenen72,
Do you want to make the ComboBox display existing users listed already in your list?
If so, you just need to refer to the column name directly in the Distinct() function.
Set the Items rpoperty of the ComboBox as:
ForAll(Distinct(list,Requestor),Value)
@v-qiaqi-msft Thanks for your help, seem like it is returning table and not able to change the Primary text at all.
How you write this formula?
I have confirmed it on my side, it works as expected.
Note that Requestor on my side is a Person type.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 381 Super User 2026 Season 2
Mohsin Ali 340
WarrenBelz 187 Most Valuable Professional
