web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collecting local colle...

Power Apps

Answered

Collecting local collection to sharepoint list

(0) Share

Report

Report

Posted on by nagestiada

504

Hey Guys, I have a collection of 30 records and I want everything to load to the Sharepoint List however there are some Columns that has different name and on the sharepoint it is a choice column and on my collection is only text. as well as on sharepoint it's Person/Group and on my end it's only TextInput1.Selected.DisplayName.

How can I do this? Please help me and thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nagestiada ,

I assume the person column do not allow multiple selections , you could try:

ForAll( CollectionName, Patch( TheSPList, Defaults(TheSPList), { SPListColumn1:CollectionColumn1, SPListColumn2:CollectionColumn2, SPListColumn3:CollectionColumn3, SPListPerson: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Department: "", Claims: "i:0#.f|membership|" & First(Office365Users.SearchUser({searchTerm:CollectionUserNameColumn})).Mail, DisplayName: CollectionUserNameColumn, Email: First(Office365Users.SearchUser({searchTerm:CollectionUserNameColumn})).Mail, JobTitle: "", Picture: "" } } ) )

Best Regards,

Bof

Was this reply helpful? Yes No
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft, Sorry, I have one column that allows multiple selection with peoplepicker and another for combobox. How do we do it?

Was this reply helpful? Yes No

Join the conversation