web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patch multiple rows fr...

Power Apps

Unanswered

Patch multiple rows from a collection to SharePoint List as an one item

(0) Share

Report

Report

Posted on by Minjinzz

Hello, everyone.

I got a problem patching my data from collection to Sharepoint list. Is it possible to patch multiple rows of collection to Sharepoint list as an one Item?

Screenshot (90).png Screenshot (91).png

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Minjinzz ,

I can only think of the hard-coded approach. Formula like this(assume that the collection has three column called "ColumnA", "ColumnB" and "ColumnC"):

Patch(listname,Defaults(listname), { Column1:First(test).ColumnA Column2:First(test).ColumnB Column3:First(test).ColumnC Column4:Last(FirstN(test,2)).ColumnA Column5:Last(FirstN(test,2)).ColumnB Column6:Last(FirstN(test,2)).ColumnC Column7:Last(FirstN(test,3)).ColumnA Column8:Last(FirstN(test,3)).ColumnB Column9:Last(FirstN(test,3)).ColumnC ... } )

Best regards,

Allen

Join the conversation