Answered

More info / example on Patch bulk updates

(0) Share

Report

Posted on by StevenMoore

I am trying to use the patch function to update the whole recordset in a Gallery control that gets it's data from MySharepointList. The code is run from a button.onselect and shows no errors but the dataset is not updated.

ClearCollect(MyCollection, Gallery.AllItems);
Patch(MySharePointList, MyCollection)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
ClearCollect(MyOriginals, {query used to create the gallery}); ClearCollect(MyCollection, Gallery.AllItems); Patch(MySharePointList, MyOriginals, MyCollection)
This may work for you.

Was this reply helpful? Yes No
Verified answer

hpkeong 2,944 on at

Like (1)

Report
Copy link

Link copied!

Hi @StevenMoore

In fact, I have posted on Patch before and recently, again, to look for shortcut to Patch in Batch. You can search my solution under hpkeong.

Anyway, I share again the method which 100% work but I don;t like due to extra work.
e.g.:
ForAll(Gallery1_1.AllItems, Patch(DS1, Defaults(DS1), {FiedTitle1: Label1.Text, FieldTitle2: Label2Text, FieldTitle3: Label3.Text}))
where,
FiedTitle1: Label1.Text ... means you must have inserted Label1, Label2, ...into the gallery.
and make the Gallery Invisible (as I don;t want view because I use for Batch Patch only).

Note:
If you are using Collect to collect all InputText into a collection, after several input,
you can use Patch(DS, CollectionTable) easily.
I am still finding out the main reason why both has different results with Michael.

Please use the first method to get it done and once I get the second one done, i will share again.

Hope this helps.

Was this reply helpful? Yes No