I have an App linked to a Share Point list and I have 2 problems:
1) I would like to have a button which fills several rows of a Share Point list, but I don't know what formula I have to use. I've tried with 'Patch' but it only works (as far as I know) with only one row.
2) I would like to apply that formula only for some fields, the ones that have an specific value in one colum. That is, all the rows that have in the colum 1 the value "x" should have (when the button is selected) the value "y" the colum 2. The value "x" is defined by election in a previous gallery of items.
There is another way to solve my problems but I don't know if it is possible. The solution would be to fill all the items filtered by a gallery simultaneously. The gallery introduces the conditions required and then the button could fill all the gallery items in the Colum2 with the value "y"