Need help with patch multiple updates in gallery

[Sketro]

Hi

I have data from O365 dynamics DS. I have built a gallery with textinput boxes to allow editing values.

Everything works except updating records, i've tried patch command here is my code:

Patch('DS',ForAll(Gallery2.AllItems,{,ds_field1:[@TextInput1],ds_field2:[@TextInput2]}))

the code runs and i see the dots but no update and no error

also what i'm not sure about is how does patch know which row to update, do i need to pass in a guid for the row ?

essentialy i have two textboxes in the gallery and one is numeric which needs to be updated

thanks for taking a look

[Meneghino]

Hi @Sketro

Please try this and let me know:

ForAll(Gallery2.AllItems, Patch('DS',{ID:ID},{ds_field1:TextInput1.Text,ds_field2:TextInput2.Text}))

The ID should be your primary key field, assuming that only one field participates in the primary key.

Once you get this to work, I can provide more efficient code.

PS Just re-read your post and you mention something about a numeric field, so for that one you need this:

Value(TextInputX.Text)

[Sketro]

@Meneghinothanks for the quick reply, 50% there, but now all values update to the same amount when i update a single cell. must be passing the wrong id somewhere.

[Sketro · Accepted solution]

ok so this was the final code. a huge shoutout to @Meneghino for going the super extra mile over skype to help get this working he really knows his stuff !!

Patch('Data source', Gallery2.AllItems, AddColumns(DropColumns(Gallery2.AllItems, "columntoedit"),"columntoedit", Value(TextInputX.Text)))

works pretty fast too.