How can I save data stored in a temporary collection to a SharePoint List?

[nzacharakis]

What I want to accomplish is to populate a Power Apps gallery with rows of data, stored in a temporary collection and when user clicks the Save button to save the data from the temporary collection to a SharePoint List, OB_Data_NIST.

In Power Apps I have a form (OA) and a gallery (OBNIST) inside that form. I am also using a temporary collection variable, TempRows

to add rows to OBNIST gallery

The OBNIST gallery is bound to TempRows collection

When I click the Add Row button a new empty row is added in OBNIST gallery. This is the code executed

Collect(
    TempRows,
    {
        OBN_ServiceName: OBNIST.Selected.OBN_ServiceName.Selected.Value,
        OBN_ProductName: OBNIST.Selected.OBN_ProductName.Selected.Value,
        OBN_Link: OBNIST.Selected.OBN_Link.Text
    }
);

 Users can add data in the OBNIST rows. When I click the Save button the following code is executed (SavedOB_ID is calculated before hand as the next ID column value)

ForAll(
    TempRows,
    Patch(
        OB_Data_NIST,
        Defaults(OB_Data_NIST),
        {
            OBN_OB_ID: SavedOB_ID,
            Title: OBTitle.Text,
            OBN_ServiceName: ThisRecord.OBN_ServiceName,
            OBN_ProductName: ThisRecord.OBN_ProductName,
            OBN_Link: ThisRecord.OBN_Link
        }
    )
);

I am trying to read and save all the TempRows into the SharePoint List, OB_Data_NIST. However, I get back an error:

       Network error when using Patch function: The requested operation is invalid 

Can someone please let me know what I am doing wrong?

Thank you in advance 🙂

[poweractivate]

Recommend not use Patch inside ForAll.
Try like this @nzacharakis 

Patch(
    OB_Data_NIST,
    TempRows,
    ForAll(TempRows, {
        OBN_OB_ID: SavedOB_ID,
        Title: OBTitle.Text,
        OBN_ServiceName: ThisRecord.OBN_ServiceName,
        OBN_ProductName: ThisRecord.OBN_ProductName,
        OBN_Link: ThisRecord.OBN_Link
    })
);

See if it helps @nzacharakis 

[nzacharakis]

Hi @poweractivate 

thank you for getting back to me. Unfortunately I get the error message below as soon as I pasted your solution

[poweractivate]

@nzacharakis 
Could I also see the screenshot without the error covering it in case?

[poweractivate]

@nzacharakis 

Hmm just in case we may need another collection for the changed records, try this as well @nzacharakis 

ClearCollect(colChangeRecs, ForAll(TempRows, {
    OBN_OB_ID: SavedOB_ID,
    Title: OBTitle.Text,
    OBN_ServiceName: ThisRecord.OBN_ServiceName,
    OBN_ProductName: ThisRecord.OBN_ProductName,
    OBN_Link: ThisRecord.OBN_Link
}));

Patch(
    OB_Data_NIST,
    TempRows,
    colChangeRecs
);

[nzacharakis]

@poweractivate 

I tried the second code snippet inside the Save button OnSelect property, (replacing the previous solution) and I got another error message:

The function Patch has some invalid arguments. Invalid argument type (Table). Expecting a Record value instead.

Cannot use a non-record value in this contect: 'colChangeRecs'.

[nzacharakis]

@poweractivate 

Here is a screen shot of the previous solution you requested

[poweractivate]

@nzacharakis 

1. Tell me what TempRows is (is it a Collection?)
2. Tell me if TempRows is empty or contains any values. Make sure to tell me if it also contains the primary key ("ID") of the SharePoint List or not. 

Temporarily we may try your inefficient way to get a quick solution for now. If so I may give you the alternate solution soon.

[poweractivate]

@nzacharakis 

Going back to your original error, try patching a single, hard coded value without ForAll

Patch(
    OB_Data_NIST,
    Defaults(OB_Data_NIST),
    {
        OBN_OB_ID: <Some Value>,
        Title: <Some Value>,
        OBN_ServiceName: <Some Value>,
        OBN_ProductName: <Some Value>,
        OBN_Link: <Some Value>
    }
);

Try it like this. Do you still get an error?
If not, then the issue may be with TempRows, which may be affecting my optimized version and even causes your original version not to work , so try and give as much info about TempRows as you can. It seems you are using Collect on using the Add row. Try going to inspect the collection here and see what are the values:

[nzacharakis]

@poweractivate 

Hi,

Yes, TempRows is a collection and I have checked before and it actually contains the data entered in the gallery OBNIST. It does not contain the key "ID" value for the following reason:

I want to mimic the relational database functionality by having 2 SharePoint lists

   1. OB_Data, 2. OB_Data_NIST

OB_Data is the "parent" record and the gallery records are its corresponding "children" in the OB_Data_NIST list, sharing the same ID key value. 

For example, if OB_Data contains a record with ID 13 then when I save its related gallery records in OB_Data_NIST, each OB_Data_NIST will have an OB_ID 13 field, including the rest of them (Title, OBN_ServiceName, etc) that links the children records to the parent list.

That is the reason I am saving the gallery records in a temporary collection and then save them into OB_Data_NIST list. I am not sure if there is a better way to do it. I just started using Power Apps a week ago. 

By the way, thank you for all the trouble to help me 😊