Ability to Copy/Apply Down Information inside of an Editable Grid in PowerApps

[CatLampMan42069]

Hello,

I am currently developing a PowerApp that allows me to edit and save information on the app to a SharePoint List. As it is currently set up, the first screen is a screen in which you can search up a given person, and a variable is passed through to the second screen that holds the person's ID/Username, this then filters down a hidden gallery to the rows only related to that given person. The second screen is currently a editable gallery that will save changes made, but I currently have to go item by item to edit it. Is there a way for me to be able to apply a specifics row's worth of information downwards? For instance, if I'm on row 8/24 and I change the person's information across all the columns in that row, is there was a way for me to create a button that changes all the rows under that one to the information I just changed it to. Or alternatively only for one column, copying the information down? 

[WarrenBelz]

@CatLampMan42069 ,

You need to replace GalleryFieldControl with the name and output of your gallery controls relating to those fields.

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.

Visit my blog Practical Power Apps

[CatLampMan42069]

Hi @WarrenBelz, it is still claiming that there is invalid number of argument for the initial patch portion of the function, and claims that "As" was not permitted in the context. What could be the reasoning for this issue?

[CatLampMan42069]

Patch(
    'TEST - FY23',
    ForAll(
        Filter(
            HiddenForeGall.AllItems, 
            RowNo >= ThisItem.RowNo
            ) As aPatch, 
            {
                ID: aPatch.ID,
                'C Percentage': aPatch.CBox.Text,
                'S Status': aPatch.SStatusBox.Selected,
                'T Status': aPatch.TBox.Selected.Value,
                Department: aPatch.DepartBox.Selected.Value
            }
    )
                

Sorry for the continued reply @WarrenBelz, I think the issue was that there was an extra parenthesis following the ForAll argument, but when I wrote the code like this. The one error it gives is that it has an invalid argument type (table) when it expects a record value instead.

[WarrenBelz]

@CatLampMan42069 ,

The code is valid unless one of your values is not valid in the context of where it is running from. Where is this? 

[CatLampMan42069]

@WarrenBelzl,

This code is currently running within the gallery, and its in the OnSelect Option for the button I added to the gallery which appears in each row of the gallery.

[WarrenBelz · Accepted solution]

@CatLampMan42069 ,

 You are also missing closing brackets off this - with the button in the gallery, you may be able to do this. It is at times problematic running code from inside a gallery referring to the gallery.

With(
   {wRow: ThisItem.RowNo},
   Patch(
      'TEST - FY23',
      ForAll(
         Filter(
            HiddenForeGall.AllItems, 
            RowNo >= wRow,
         ) As aPatch, 
         {
             ID: aPatch.ID,
             'C Percentage': aPatch.CBox.Text,
             'S Status': aPatch.SStatusBox.Selected,
             'T Status': aPatch.TBox.Selected.Value,
             Department: aPatch.DepartBox.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.

Visit my blog Practical Power Apps

[CatLampMan42069]

@WarrenBelz 

With(
   {wRow: ThisItem.RowNo},
   Patch(
      'TEST - FY23',
      ForAll(
         Filter(
            HiddenForeGall.AllItems, 
            RowNo >= wRow,
         ) As aPatch, 
         {
             ID: aPatch.ID,
             'C Percentage': Value(aPatch.CBox.Text),
             'S Status': aPatch.SStatusBox.Selected,
             'T Status': aPatch.TBox.Selected.Value,
             Department: aPatch.DepartBox.Selected.Value
         }
      )
   )
)    

@WarrenBelz This code showed up without any issues! Whenever I clicked on the button however, none of the values of the rows below the one's whose value I edited appeared to change along with it. 

[WarrenBelz]

@CatLampMan42069 ,

It should work assuming you have the same ID in the gallery as you have in the list and (you need to check this) the fields you are patching to are the same data type as the output of the gallery controls. I have one more suggestion then I am out if ideas. Try a button outside the gallery with

With(
   {wRow: HiddenForeGall.Selected.RowNo},
   Patch(
      'TEST - FY23',
      ForAll(
         Filter(
            HiddenForeGall.AllItems, 
            RowNo >= wRow,
         ) As aPatch, 
         {
             ID: aPatch.ID,
             'C Percentage': aPatch.CBox.Text,
             'S Status': aPatch.SStatusBox.Selected,
             'T Status': aPatch.TBox.Selected.Value,
             Department: aPatch.DepartBox.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.

Visit my blog Practical Power Apps

[CatLampMan42069]

@WarrenBelz Okay, thank you for your patience and help! 

[CatLampMan42069]

@WarrenBelz, I worked with the code a bit, and I found that simply just using the name and output of my fields allowed me to apply it down. Thank you so much for this!

With(
   {wRow: HiddenForeGall.Selected.RowNo},
   Patch(
      'TEST - FY23',
      ForAll(
         Filter(
            HiddenForeGall.AllItems, 
            RowNo >= wRow,
         ) As aPatch, 
         {
             ID: aPatch.ID,
             'C Percentage': Value(CBox.Text),
             'S Status': SStatusBox.Selected,
             'T Status': TBox.Selected.Value,
             Department: DepartBox.Selected.Value
         }
      )
   )
)