cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Blinkorta
Frequent Visitor

Patch all items in Gallery

 

PowerApps2.JPGI don't know if this is possible. I've seen other posts online of people exploring saving things in a Gallery but i'm not sure if my specific setting will work. Basically I have a Gallery that shows the "astID" field of a Collection and a textbox that shows the "astExplanation" field from the same collection. I want the user to be able to fill in the textboxes then click Save and have all the records in the gallery patched or updated with the new data. This is what I currently have on the Save button. I don't have any errors but it doesn't work. Nothing happens when clicked. 

 

ForAll(Gallery3.AllItems, Patch(tblInvenTemp, {astID: Label34.Text},{astExplanation:TextInput3.Text}))

And I know I should rename the label and textbox.  

11 REPLIES 11
Matthewvize
Helper I
Helper I

For new records using patch the record would be Defaults(DataSource) 

Just to complete your answer, this worked for me:

IfError(
    ForAll(
        myGallery.AllItems,
        Patch(
            [@myTable], //The table name to update. [@...] is mandatory.
            ThisRecord, //Get current ForAll item
            {
                'tableColumn1': myInput1.Text, //Update column of table with input text in gallery.
                'tableColumn2': myInput2.Text,
                'tableColumn3': myInput3.Text
            }
        )
    ),
    Notify("Error saving records")
);
Refresh(myTable)

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,167)