Answered

Insert Multiple People Picker Field to SharePoint From PowerApps Gallery Combo Box

(0) Share

Report

Posted on by kameshm

Hi,
Now I am working on PowerApps that includes a gallery control.The Gallery Control consist of ComboxBox Associate with Office365Users Connectors. I have one MultiPerson Field in sharepoint. I want Insert all gallery items to sharepoint list includes that people combobox selected values also. But How to insert all comboxbox selected items to sharepoint.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @kameshm

You need to change the data structure of selected Office365Users from combobox to fit the structure of Person field in SharePoint.

The data structure of multi-select person field is a table with Chaims, Email, Department, JobTitle, Picture column.

If you are try to use ForAll function to save all gallery items to sharepoint list, I made a similar test, and the code should resemble this:

ForAll( GalleryName.AllItems, Patch( 'SP list', Defaults('SP list'), { Title:ThisRecord.TextInputName.Text, PersonFieldName: DropColumns( AddColumns( ShowColumns( ThisRecord.ComboBoxName.SelectedItems, "Mail" ), "Claims", "i:0#.f|membership|" & Mail, "Department", "", "DisplayName", "", "Email", "", "JobTitle", "", "Picture", "" ), "Mail" ) } ) )

Hope this helps.

Sik

Was this reply helpful? Yes No
kameshm 59 on at

Like (0)

Report
Copy link

Link copied!

@v-siky-msft Yeah Thanks. Its working. I have another problem over. I have one ComboBox Its show only one People at a time. By default I set the defaultselecteditems by below

Table({
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|"&Gallery2.Selected.Organizer ,
DisplayName:Office365Users.UserProfile(Gallery2.Selected.Organizer).DisplayName
,
Email:Gallery2.Selected.Organizer
})

But My problem is I can,t get email value fromc combobox. I am using Below rule
ComboxBox.Selected.Mail. But It didnt give any mail. Am missing something else

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @kameshm ,

What is the Items property of combo box? What is Gallery2.Selected.Organizer?

It seems the combobox.items is office365 users, right? If so, your DefaultSelectedItems is wrong as the data structure is for Person field of SharePoint, please modify as follows.

Office365Users.SearchUser() //Items property of combobox

Office365Users.SearchUser({searchTerm: Gallery2.Selected.Organizer }) //DefaultSelectedItems property of combobox

Hope this helps.

Sik

Was this reply helpful? Yes No
kameshm 59 on at

Like (0)

Report
Copy link

Link copied!

@v-siky-msft Thanks . Its also worked.

Was this reply helpful? Yes No