update sharepoint list person with combobox

(0) Share

Report

Posted on by trogne

My data is a sharepoint list. It includes a "Person" type.

In Power Apps, I have a combobox that displays the person correctly.

The combobox also searches the persons correctly.

But when I want to update the collection, I have an error :

UpdateIf(

colGridUpdates,

ID = ThisItem.ID,

{

Titre: txtTitle.Value,

Description: dpDescription.Value,

'Due Date': dpDueDate.SelectedDate,

Priority: {Value: dpPriority.Selected.Value},

Auteur: {Value: combobox_usagers.Selected}

}

)

Error here :

combobox_usagers.Selected

It says "Expecting a record value, but of a different schema."

"combobox_usagers.Selected.Value" does not work either.

How can I send a "Record" type back to Sharepoint ?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@trogne -

The answer will depend on what you have in the Items property of your "combobox_usagers" ComboBox control, and whether the person column in your SharePoint list is single-select or multi-select.

As a start however, have you tried:

Auteur: combobox_usagers.Selected

Was this reply helpful? Yes No
james1994 231 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @trogne,

The error is occurring because you are patching a record with the field "Value" into that Person column.
combobox_usagers.Selected.Value would not work either as that will return text, where you need to provide a record.

What is the data for your combo box? Does the data source have an email column? If it's a list of your AD, you could just use:

Auteur: combobox_usagers.Selected

If that doesn't work, then you can refer to Matthew Devaney's blog post on how to patch a person type column:
PATCH A SharePoint Person Column In Power Apps - Matthew Devaney

Specifically, you'd need to patch the person column with a record containing Claims data (assuming your combo box is able to return an email for a selected record):

UpdateIf( colGridUpdates, ID = ThisItem.ID, { Titre: txtTitle.Value, Description: dpDescription.Value, 'Due Date': dpDueDate.SelectedDate, Priority: {Value: dpPriority.Selected.Value}, Auteur: { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: $"i:0#.f|membership|{combobox_usagers.Selected.Email}", Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" } } )

Was this reply helpful? Yes No
trogne 59 on at

Like
a
(0)

Report
Copy link

Link copied!
This line seems misplaced :
{Value: combobox_usagers.Selected}

Was this reply helpful? Yes No
james1994 231 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that was something I had forgotten to remove. Apologies.

Was this reply helpful? Yes No
trogne 59 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks James,
Can you have a look at :
https://powerusers.microsoft.com/t5/Building-Power-Apps/confusion-over-a-collection-not-getting-cleared-because-of-one/td-p/2646802

For my combobox "Items" property, instead of using :
Filter( Office365Users.SearchUserV2( { searchTerm: Trim(Self.SearchText), isSearchTermRequired: false } ).value, AccountEnabled = true && Not("#EXT" in UserPrincipalName) )

I now just use Choices(Tasks.Auteur).

That way, in my UpdateIf, I can simply have "Auteur: combobox_usagers.Selected".

But as you will see, I have a very strange behavior : my "update" collection does not get cleared!

Was this reply helpful? Yes No