Saving people or person via combo to people or person column

(0) Share

Report

Posted on by Sifu

834

having a combobox where i select people and groups (but really only people and no groups).

having a colum that is "people or groups" and using its update property to capture data from the combobox mentioned above with this code:

{
 Claims: "i:0#.f|membership|" & ('combo'.Selected.Result),
 DisplayName: 'combo'.Selected.Result,
 Email: 'combo'.Selected.Result,
 Department: "", 
 JobTitle: "", 
 Picture: ""
}

Problem is that this will save only one person, cant figure out how to save multiple

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

JayMagness 1,663 on at

Like
a
(0)

Report
Copy link

Link copied!

HI,

Is this is SharePoint?

I will send you my contact information

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sifu ,
You would use
ForAll( YourComboBoxName.SelectedItems, Patch . . .

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sifu ,

Could you please share a bit more about the formula you typed within the Items property of the ComboBox?

Could you select multiple options within the ComboBox?

Further, could you please share more details about the result the 'combo'.Selected.Result formula returned? Is it a email address or a Display name of the user?

According to the needs that you mentioned, I think you want to save the multiple selected users within the ComboBox back to the Person type column in your SP List, is it right?

1) If the 'combo'.Selected.Result formula result is the email address of a selected user, please modify your formula as below (set the Update property of the Person field data card in your Edit form😞

ForAll( 'combo'.SelectedItems, { Claims: "i:0#.f|membership|" & Lower(Result), DisplayName: LookUp(Office365Users.SearchUserV2().value, Mail = Result).DisplayName, Email: Result, Department: "", JobTitle: "", Picture: "" } )

Note: You need to add Office 365 Users connector as data source in your app firstly

2) If the 'combo'.Selected.Result formula result is the DisplayName of a selected user, please modify your formula as below (set the Update property of the Person field data card in your Edit form😞

ForAll( 'combo'.SelectedItems, { Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUserV2().value, DisplayName = Result).Mail), DisplayName: Result, Email: LookUp(Office365Users.SearchUserV2().value, DisplayName = Result).Mail, Department: "", JobTitle: "", Picture: "" } )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No