News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Person Type column in ...

Power Apps - Building Power Apps

Answered

Person Type column in combobox

Like (0) Share

Report

Report

Posted on 28 Mar 2024 06:04:59 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:

Using Apps Using Formulas

General Questions

All responses Img

All responses (4)

Answers Img

Answers (1)

Danny_Dicaprio on 28 Mar 2024 at 06:55:32

Like (0)

Report

Re: Person Type column in combobox

@v-jefferni Thanks for the knowledge
Verified answer

v-jefferni on 28 Mar 2024 at 06:42:46

Like (1)

Report

Re: Person Type column in combobox

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,
Danny_Dicaprio on 28 Mar 2024 at 06:21:28

Like (0)

Report

Re: Person Type column in combobox

@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 ?
v-jefferni on 28 Mar 2024 at 06:11:40

Like (1)

Report
Re: Person Type column in combobox

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,