Users are not submitted to SharePoint list

(0) Share

Report

Posted on by LB-22071322-0

Hi there,

I just started trying out Power Apps for my company and wanted to build an app for vacation submissions.

One of fields in the form is related to the substitute of the requestor. There, the user searches for Office365 users in the domain.

Filling out this field works just fine, but when I submit the form and check the SharePoint entry, all filled out fields are good except the substitute column. This one is empty.

The column in SharePoint is a "Users & Groups" type. In the app, it is a searchable Combo box with multi select enabled.

Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

did you check the update property of the datacard? which value is in there?

do you use patch() or submitform()

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @LB-22071322-0,

As @mmbr1606 has suggested, this is one of the issues with using Office365Users in the Items of a Combo Box writing back to a Person field. This gets more complex when the control and field are multi-select/value. If your Combo Box Items are something like
Office365Users.SearchUserV2( { searchTerm: Self.SearchText, isSearchTermRequired: false, top: 999 } ).value

then the schema returned is different from that of a Person field. There are two areas that you need to address - the Update of the Data Card
ForAll( ComboBoxName.SelectedItems As _Items, { Claims: "i:0#.f|membership|" & Lower(_Items.Mail), Department: "", DisplayName: _Items.DisplayName, Email: _Items.Mail, JobTitle: "", Picture: "" } )

and the DefaultSelectedItems of the Combo Box so existing values can be captured and subsequently saved on existing records
ForAll( ThisItem.YourPersonFieldName As _Items, { DisplayName: _Items.DisplayName, Mail: _Items.Email } )

Please click Does this answer your question 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 a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
LB-22071322-0 4 on at

Like (0)

Report

Hi @WarrenBelz & @mmbr1606.

Thank you for the support. That was exactly what was missing. Transfer is now working as intended.

Cheers!

Was this reply helpful? Yes No