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 ,

This structure will do it

ForAll(
   Filter(
      YourGalleryName.AllItems,
      YourFilterHere
   ) As aFiltered,
   Patch(
      studenttrackermaster2,
	  {UPN:aFiltered.UPN},
	  {
         Comments:TextInput1_2.Text,
         maths_WorkCompletion:Dropdown2_2.Selected.xxx,
         maths_engagement:Dropdown2_8.Selected.xxx
      }
   )
)

Note xxx is whatever the .Selected. value is for the control (Value/Result/Field Name)

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]

Thank you for the swift reply!

currently the gallery is filter like so Filter(studenttrackermaster2,Maths.Value=Dropdown1_2.Selected.Value)

how would i add this for the gallery filter?

[WarrenBelz]

@marc2510 ,

No need to if your gallery is already filtered - I assumed you wanted to add a filter to it

ForAll(
   YourGalleryName.AllItems As aFiltered,
   Patch(
      studenttrackermaster2,
      {UPN:aFiltered.UPN},
      {
         Comments:TextInput1_2.Text,
         maths_WorkCompletion:Dropdown2_2.Selected.xxx,
         maths_engagement:Dropdown2_8.Selected.xxx
      }
   )
)

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]

Sorry to be a pain but I'm getting this error? ( see attached)
again sorry!

@WarrenBelz 

[marc2510]

To get rid of the error, I added Gallery1_1.Allitems


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

but this then makes changes to all items on the list 

[WarrenBelz]

@marc2510 ,

I was using your values here as you posted that UPN was the common key between the tables. What type of field is UPN?

[marc2510]

UPN is the unique value given to each user (like an ID) 

UPN is just a text field.

I’m very grateful for all the support on this

[WarrenBelz]

@marc2510 ,

I have fixed the AllItems - dangers of free-typing.

Why are you getting the error that UPN was expecting a Table?

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]

@WarrenBelz  The error has now gone when using the all items.
When i am using the ForAll function it is saving all the records the same instead of treating each row of data individually?

for example if i add a comment to the user with UPN 681 - it then changes all the other users comments to the same. I want it to save each row individually