Unanswered

Multiselect Person Column in Power Apps Not Appearing in SharePoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've create a form in my Power App. I've added 2 different data cards w/ combo boxes for 2 different columns I created that's a person / group column in SharePoint.

Two issues are happening:

For one column, nothing (display name) is appearing (just showing blank) back in the SharePoint list for the person I've selected. My update fx for the data card is datacardname.selected.
For the other column, the display name is appearing for one name only. I have multi-select on in PowerApps. I also tried doing multi select in SharePoint but get an error in PowerApps if I have it also selected as an option in PowerApps. My update fx for the data card is also datacardname.selected.

My submit button is submitform(form name here). Any idea whats going wrong here?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try using Patch with the below approach to set the multi-select people field in SPList:
Patch(SampleList,Defaults(SampleList),{Title:"Sample", PersonEmail:ForAll( DataCardValue181.SelectedItems, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Email, Department:"", DisplayName:DisplayName, Email:Email, JobTitle:"", Picture:"" } )});

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So that didn't work, but I changed my person / group column in SharePoint to "multiple selection" and did the same in PowerApps with the multiple select toggle on. I changed my update in the data box (it's a form) to selecteditems. For one column, this worked and appears the Display Name per selected person with a "," separator in SharePoint (though it appears as [Object] in a table view I have on another screen in PowerApps). When I replicate the above steps for my other columns w/ person look up groups and refresh my data set, I get a bunch of errors in the default option of the combo box and data card. I removed the default option, but when submit using submitform() I receive "an unknown error has happened" and nothing works now. Does anyone have step by step instructions using a SharePoint list person / group column, a new form display in PowerApps for multi-person selection options?

Was this reply helpful? Yes No