DefaultSelectedItems for People picker Combobox from email ID as plain text

(0) Share

Report

Posted on by Sriram6000

I'm having trouble with multi selection people picker combo box displaying the default selected items. I am not able to figure out how to set it up.

With Sharepoint list as data source, email IDs are stored as plain text in a text column with multiple email IDs semi colon separated.

What is the approach i should take, to populate the Default Selected Items property of the Combo box such that the emails IDs from the SPL text columns preselected in the combo box.

I tried the below, missing out something. Any help is appreciated.

DefaultSelectedItems =

{
Claims: Concatenate("i:0#.f|membership|", varDataCardValue94 // varDataCardValue94 :- Person email Id from SPL Text column
),
Department: "",
DisplayName: ShowColumns(Office365Users.SearchUserV2({searchTerm:varDataCardValue94}).value, "DisplayName"),
Email: varDataCardValue94, // Person email
JobTitle: "",
Picture: ""
}

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

raks on at

Like (0)

Report
Try this:
Filter(--copy here the request you have in items--, Email = varDataCardValue94.Email)

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @SS13,

Do you want to retrieve users based on multi email address?

Could you please tell me that how you set the Items property of the people picker?

Modify your formula as below:

ForAll(Split(DataCardValue94.Text,";"),First(Office365Users.SearchUser({searchTerm:Value})).DisplayName)

Was this reply helpful? Yes No