Patch all items in a filtered Gallery

[marc2510]

Hello,

Im struggling to work out a solution to patch all items in a filtered gallery.

this is what i use to patch a single record 

Patch(studenttrackermaster2,ThisItem,{Comments:TextInput1_2.Text},{maths_WorkCompletion:Dropdown2_2.SelectedText},{maths_engagement:Dropdown2_8.SelectedText})

I have attached an image for example
my unique field for each = "UPN"

[WarrenBelz]

Hi @marc2510 ,

Firstly, the ForAll with the reference to the UPN should do this, so there is something wrong in either the reference match or the values you are patching. I have assumed (from your posts) that the both the Gallery and studenttrackermaster2 have fields called UPN.

Firstly get rid of .SelectedText and replace with (I assume they are Choice columns) with .Selected.Value

Next what are the Items of your Gallery and what are the names of the fields (in the list) that your two drop-downs and text box are linked to?

[marc2510]

Yes the gallery and data source have the the UPN data



When I change from .SelectedText to Select.Value (which I assumed it should be because of the choice field from SP.  I get the following error.

[WarrenBelz]

@marc2510 ,

Firstly, I keep seeing different fields in the Patch - I assume that they are all of the same field type. What type are these (I hope Choice) - if so are they single or Multi-choice? If a Single Choice

ForAll(
   Gallery1_1.AllItems As aFiltered,
   Patch(
      studenttrackermaster2,
      {UPN: aFiltered.UPN},
      {
         Comments: TextInput1_1.Text,
         Eng_WorkCompletion: {Value:Dropdown2_1.Selected.Value},
         Eng_engagement: {Value:Dropdown2_7.Selected.Value}
      }
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz · Accepted solution]

Hi @marc2510 ,

After our discussion and your renamed controls

ForAll(
   RenameColumns( 
      Gallery1.AllItems,
      "ID",
      "ID1"
   ),
   Patch(
      studenttrackermaster2,
      {ID: ID1},
      {Comments: TextComments.Text},
      {Art_WorkCompletion: {Value: ddCompletion.Selected.Value}},
      {Art_engagement: {Value: ddEngagment.Selected.Value}}
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[marc2510]

Perfect!