unable to patch collection to sharepoint list

(0) Share

Report

Posted on by karthik26

101

I created a collection and added data when a button is clicked.

with the same column name as SharePoint.

But while patching to sharepoint it is showing error.

i want to patch the collection to sharepoint.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

AndrewR1 1,572 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @karthik26 you can try doing it this way:

ForAll( Yourcolection As ITEM, Patch( YourSPList, Defaults(YourSPList), { SPListCoulnmName1: Item.ColumName1, SPListCoulnmName2: Item.ColumName2 } ) )

This is the general idea but you would loop through each item and then patch a new record to the SharePoint list.

Hope this helps!

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

Was this reply helpful? Yes No
NPPlatform 606 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, what does the error on your Patch()-formula say?

Was this reply helpful? Yes No
MLe92 33 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
if you want to patch a collection to SharePoint, you also need the ID.
Add the ID field and use the following code to perform the patch.

Patch('FM Calculator results', ColFMdata.ID, ColFMdata )

It is important that the column names are entered correctly 1:1.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @karthik26 ,

If you want to use that structure to (I assume) create new records in the SharePoint list, then all fields in the collection need to exist in the SP list in both exact name and field type. Is this the case ?

Was this reply helpful? Yes No
MLe92 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Andrew,

it's a common way, but not the most powerful way.

Patch a collection is the best way.

Was this reply helpful? Yes No