Powerapps is not submitting to sharepoint people column

(0) Share

Report

Posted on by nchandran

426

Hi,

I'm facing problems with the people column in a SharePoint list. Apparently i built an app with multiple forms and then patching to the SharePoint list. All the columns are filled except the people column name 'empname'.

The form name is ReqForm1, i went to check the data card and datacardvalue properties not sure where i went wrong.

Patch syntax is -> Patch(Slist, Defaults(SPlist), RequestForm1.Updates,RequestForm2.Updates, RequestForm3.Updates, RequestForm4.Updates, RequestForm5.Updates)

These are the details of the data card and datacardvalue

Field Input is Combo box.

Data card Properties

Default - ThisItem. Empname

Update - DataCardValue12.Selected

DataCardValue12 Properties

Default - empty

Items - Choices([@Slist].EmpName)

DefaultSelectedItems - If(RequestForm1.Mode=FormMode.New,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",Claims: "i:0#.f|membership|"&User().Email,DisplayName: User().FullName},Parent. Default)

SharePoint connected to this app are Slist and O365users, shown below are screenshots of the SharePoint Column and the on start property of the App.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

jatcube 508 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nchandran ,

The person column is a complex column (essentially a lookup column to other columns, co need to be patched slightly differently.

Check out this guide on how to patch these different complex columns http://powerappsguide.com/blog/post/sharepoint-applying-patch-to-the-6-complex-data-types

Or, based on your user case, you can use a form and the
SubmitForm
will take care of all the underlying syntax for you.

Hope that helps.
Verified answer

nchandran 426 on at

Like
a
(0)

Report
Copy link

Link copied!

Managed to solve this problem by creating a new people's column to replacement the current and updated the patch syntax on the submit button by removing and re-add form1.updates.