Patch Multiple Records - Duplicate Information

[gengeset]

I've created a Time Reporting app and am looking to export that data to my SharePoint List. I've gotten the Patch Function to work with one instance, however I'm looking to have multiple submissions sent to the SharePoint List with the same "Week Ending" date associated with each row. For example:

• Client X | 5 | Test Notes | 10/8/22
• Client Y | 35 | Test Notes 2 | 10/8/22
• Client Z | 55 | Test Notes 3 | 10/8/22

A screenshot of my App is included. Is this possible?

[TheRobRush]

You will need to do a

 Patch(

           ForAll()

          )

that way you can loop through each of those items and patch each of them in

[gengeset]

In testing this with 2 of the sections of the app, I'm receiving two separate errors:

- Invalid number of arguments: received 10, expected 2.

- Invalid number of arguments: received 1, expected 2.

Here is the formula I'm using, which is undoubtedly wrong ha. What do I need to do to separate the entries in the ForAll function?

Patch(
ForAll(
'Time Entries v1', Defaults( 'Time Entries v1'), {'Week Ending': TextInput2_2.Text},{'Percent of Time': Percent_2.Text}, {'Notes': Notes_2.Text},{'Client': Client_dd_1.SelectedText.Value},{'Week Ending': TextInput2_2.Text},{'Percent of Time': Percent_1.Text}, {'Notes': Notes_1.Text},{'Client': Client_dd.SelectedText.Value}
)
)

[TheRobRush · Accepted solution]

Just going to give you an example of how these work, because I am not familiar with your layout.

To start off, all the sections highlighted in red here are going to need to be in a control that CAN be looped through, for example, a gallery.

If your data is not currently set up like that (Looks like it is not, and is more like a a bunch of controls stacked on 1 screen) you are going to need to set it in a gallery and have a selector outside that will load X number of records, say choose # clients on a dropdown or text box etc and hcanging that triggers a collection of blank records that the gallery displays, they can then fill these in and then hit a button that loops through GalleryName.AllItems and send those in via your patch.

If theres no way you can take time to redo this as a galleyr your button to submit will need to do something similar to

Collect(tempColl, {Value:Dropdown1.Selected.Result},
                  {Value:Dropdown2.Selected.Result},
                  {Value:Dropdown3.Selected.Result},
                  {Value:Dropdown4.Selected.Result},
                  {Value:Dropdown5.Selected.Result},
                  {Value:Dropdown6.Selected.Result},
                  {Value:Dropdown7.Selected.Result});
RemoveIf(tempColl,IsBlank(Value)) 

This will give you a list of results to loop through via controls only and not a gallery

The actual patch will go something like this, might have to edit slightly but tried to get close to your example data

Patch(
////SP LIST TO RECEIVE NEW RECORDS
'Time Entries v1',
ForAll(
////RECORDS TO PATCH IN **SHOWING TEMPCOLL EXAMPLE
tempColl, 

{
 'Week Ending': TextInput2_2.Text,
 'Percent of Time': Percent_2.Text,
 'Notes': Notes_1.Text,
 'Client': ThisRecord.Value
}))