I 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.
Solved! Go to Solution.
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)
User | Count |
---|---|
254 | |
106 | |
96 | |
51 | |
39 |