Power App New Form - SharePoint Multi Person Column

(0) Share

Report

Posted on by Spedoo41225

Hi All 🙏

I have a question that is getting me crazy in power apps... i have a simple sharepoint list with a person column on it.

I want to simply create a power app form so the user can add a new record in the list while submiting a new form. I managed to create the form and a people picker iniside it with a combo box.

The problem is that when i click on submit the new record is created but only the first person selected in the compo box arrives to the sharepoint list and not all the persons.

I think i need to cusomize the upate property of the data card to create a collection (array) that have the below structure:

{
         Claims: "<userPrincipalName>",
         DisplayName: "",
         Email: "",
         Picture: "",
         Department: "",
         JobTitle: ""
      }
....repeted for each person selected.... 
 
Would you have any suggestion ?
 
Thanks a lot 

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,929 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi Spedoo41225
A couple of things here that will depend on the Items of the Combo Box. If you are simply using Choices(ListName.FieldName) and (I assume) your Person field in SharePoint is multi value, delete the card and then re-add it and Power Apps will take care of all the settings.
If you are using Office365Users.SearchUser, then the schema output of the Combo Box is different to that of the field in SharePoint, so your Data Card Update needs to be
ForAll( ComboBoxName.SelectedItems As _SI, { Claims: "i:0#.f|membership|" & Lower(_SI.Mail), Department: "", DisplayName: _SI.DisplayName, Email: _SI.Mail, JobTitle: "", Picture: "" } )

and the Combo Box DefaultSelectedItems
ForAll( ThisItem.PersonField 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.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

1 people found this reply helpful.

Was this reply helpful? Yes No
Spedoo41225 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WarrenBelz,

Unfortunately is not working. my combobox is named combobox2 and i get the error message that for the update property it expect a record value and the updatedefault items invald argument type

In the items property i have:

Office365Users.SearchUserV2({searchTerm:Self.SearchText,isSearchTermRequired:false,top:10}).value

Any suggestion ?

Thanks a lot

Was this reply helpful? Yes No
WarrenBelz 155,929 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Assuming that your person field is multi-value, works perfectly here - I assume you are using a Classic Combo Box ?

Was this reply helpful? Yes No
Spedoo41225 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WarrenBelz,

Yes i'm using a classic combo box:

In the update property it expect a record value.

Below i'm sharing the column settings of the column from the list:

Not sure of you have any suggetion...

Thanska lot

Was this reply helpful? Yes No
WarrenBelz 155,929 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Something definitely not right here - is that a Modern or Class Form ? If Modern, I suggest you revert to Classic with all Classic Controls as Modern controls are still mostly in Preview and should not be used on Production apps.

Was this reply helpful? Yes No