Person Type column in combobox

(0) Share

Report

Posted on by Danny_Dicaprio

Hi Everyone ,

I have a person type column in my sharepoint list

In my power app I have a combobox with following items property (Multiselect)

Office365Users.SearchUser({searchTerm: ComboBox1_1.SearchText})

when the form is submitted , the values( the peoples name ) are not getting recorded in the sharepoint list

Could anyone please help me to fix the issue

is it because of the DSI of the combobox

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ,

Please try and use below formula in Update of the Data Card:

ForAll(ComboBox1_1.SelectedItems, {Claims: ThisRecord.Mail})

In DSI property, needs to populate the combo box with records from the table which is the Items property:

ForAll(ThisItem.PeopleColumnName, First(Office365Users.SearchUser({searchTerm: ThisRecord.Email})))

Best regards,

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni

Thanks for the reply, that worked perfectly fine
if you don't mind Could you please explain the change in the update property

Also I have anothercombobox with similar items property *which is not a multiselect combobox
will there be any different in the formula ?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Danny_Dicaprio ,

SharePoint People column requires the table structure:

single selection: {Claims: Email} //a record

multiple selections: [{Claims: Email1},{Claims: Email2},{Claims: Email3}] //a table

For the single selection people column, Update should be:

{Claims: ComboBox.Selected.Mail}

DSI: First(Office365Users.SearchUser({searchTerm: ThisItem.ColumnName.Email}))

Best regards,

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni Thanks for the knowledge

Was this reply helpful? Yes No