Save Gallery in Sharepoint

(1) Share

Report

Posted on by MiniMax92

151

I would like to save my entire collection in a SharepointList. But I don't want to have to click on every single article for the patch formula, I really just want to click on a button and it then saves everything in a SharepointList.
I've tried a bit to create a collection and then try to transfer it, but somehow it doesn't work. Is there a way?

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Sort by

WarrenBelz 156,051 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Can you please share the code (in Text) that you have attempted and the result of this.

Was this reply helpful? Yes No
MiniMax92 151 on at

Like
a
(1)

Report
Copy link

Link copied!
I try it with:

ForAll(Sharepointlist;Patch(Sharepointlist;{'Ordered Value': Value(TextInput1_2.Text)}))

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

Like
a
(1)

Report
Copy link

Link copied!

You are patching it to itself- you cannot do this - you need to Patch the collection

Was this reply helpful? Yes No
MiniMax92 151 on at

Like
a
(1)

Report
Copy link

Link copied!
Oh my Bad.

But it isn't still working.

I Try it with this formular:

Patch(Sharepointlist; Col_fin )

The error Message: Invalid argument type (table). A record is expected at the moment.

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

Like
a
(1)

Report
Copy link

Link copied!

Can you please tell me exactly what you are trying to do here. Do you want the entire collection to be sent to SharePoint as new records ? If so is every field in the collection also in the list with exactly the same name and data type ?

Was this reply helpful? Yes No
MiniMax92 151 on at

Like
a
(1)

Report
Copy link

Link copied!

I would like to add articles in my gallery to a SharePoint list at the click of a button. But all articles that are in the gallery. Not just the selected ones.

Was this reply helpful? Yes No
MiniMax92 151 on at

Like
a
(1)

Report
Copy link

Link copied!
I've now tried something again and at least for the first time in Sharepoint, it works. But he doesn't do it for the others, even though "ForAll" is supposed to apply that to the gallery.

ForAll( Gallery1.AllItems; Patch(SP_List; LookUp( Gallery1.AllItems; ID = ThisRecord.ID; ThisRecord ) ; { Abschluss: "Ja" } ))

Don't understand why it doesn't apply to every record in the gallery.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

There are 2 ways we can achieve this

1. Send Values from Canvas App to Power Automate

// Define the collection variable ClearCollect(GalleryItems, Gallery.AllItems); // Convert collection to JSON Set(jsonData, JSON(GalleryItems, JSONFormat.IncludeBinaryData)); // Run the flow YourFlow.Run(jsonData);

2. Use below code to save to SP

ForAll( MyCollection, Patch( TEST, Defaults(TEST), { Name: ThisRecord.Name, Title: ThisRecord.Title } ) );

Follow me for Move videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
MiniMax92 151 on at

Like
a
(1)

Report
Copy link

Link copied!
Ok, that almost worked. I now have the problem that it creates a new data set in SharePoint every time and does not update the existing one. This is my formula:

ForAll( Gallery1.AllItems; Patch( SP_List ; Defaults(SP_List) ; { Abschluss: "Ja" } ))

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Something like this might work

ForAll( Gallery1.AllItems As _article; With( { _record: If( IsBlank(LookUp(SP_List; ID=_article.ID)); Defaults(SP_List); LookUp(SP_List; ID=_article.ID) ) }; Patch( SP_List; _record; _article ) ) )

Was this reply helpful? Yes No