Answered

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:

Connectors

Dataflows

Using Apps Using Formulas

All responses (2)

Answers (1)

Verified answer

WarrenBelz 148,833 Most Valuable Professional on at

Like (0)

Report
Users are not submitted to SharePoint list

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 Buy me a coffee
Suggested answer

mmbr1606 13,266 Super User 2025 Season 2 on at

Like (0)

Report

Users are not submitted to SharePoint list

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

do you use patch() or submitform()