Patch Multiple Records to Excel (not in a collection)

[gbach2290]

I'm trying to patch multiple records to a connected Excel table. I'm able to send one record but I have multiple fields I need to patch to this spreadsheet. I thought by adding a comma after the first set of "curly brackets" and adding a duplicate, this would allow me to patch data from other fields...but it seems like it's only patching the information from the second set of curly brackets.  What am I missing?

This works fine....

Patch(
    ALCLogData,
    Defaults(ALCLogData),
        {
            Date: Today(),
            Location: txtLocationHeader.Text,
            Item: "Station 1 CPU",
            Status: If(selectK1121_S1_SystemChecked_btn,"Checked","Not Checked")
        }
);
Navigate(MainMenu, ScreenTransition.Fade)

This doesn't...

Patch(
    ALCLogData,
    Defaults(ALCLogData),
        {
            Date: Today(),
            Location: txtLocationHeader.Text,
            Item: "Station 1 CPU",
            Status: If(selectK1121_S1_SystemChecked_btn,"Checked","Not Checked")
        }, 
{
            Date: Today(),
            Location: txtLocationHeader.Text,
            Item: "Station 1 CPU",
            Status: If(selectK1121_S1_SystemUpdated_btn,"Updated","Not Updated")
        }
);
Navigate(MainMenu, ScreenTransition.Fade)

[subsguts · Accepted solution]

I don't think you can feed it multiple records as you have in your 2nd example:

I recommend looking at the @mdevaney example on the following blog who has an example of how to do this (not with Excel), but believe it should still conceptually be the same:

https://www.matthewdevaney.com/7-ways-to-use-the-patch-function-in-power-apps-cheat-sheet/#4.-Create...

Hope this helps

[gbach2290]

Using that example, I tried composing this but there are numerous errors:

ClearCollect(
colTest,
    {Date: Today(), Location: txtLocationHeader.Text, Item: "Station 1 CPU", Status: If(selectK1121_S1_SystemChecked_btn,"Checked","Not Checked"},
    {Date: Today(), Location: txtLocationHeader.Text, Item: "Station 1 CPU", Status: If(selectK1121_S1_SystemUpdated_btn,"Updated","Not Not Updated"}
);
Patch(
    ALCLogData,
    ForAll(
        Sequence(CountRows(colTest)),
        Defaults(ALCLogData)
    ),
    colTest
);

Navigate(MainMenu, ScreenTransition.Fade)

[subsguts]

What are the error messages.  I'm fairly sure you'll have to go down this path to get the results you want so let's keep fighting 😁

To start I would break the ClearCollect and the Patch into two separate buttons so we can see which one is causing the errors.  They might both have issues, but this should help narrow things down.

My guess is the structure of the ClearCollect doesn't match the excel spreadsheet table.

BTW, if you have a copy of the spreadsheet that is empty and/or doesn't contain sensitive info, attach it as then I can try to duplicate the code as well.

[subsguts]

One other thing, what types of controls are:

selectK1121_S1_SystemChecked_btn and selectK1121_S1_SystemUpdated_btn

It appears in your code they should be check boxes, but wanted to make sure.

[subsguts · Accepted solution]

Here's the corrected ClearCollect statement, you had a few syntax issues is all:

ClearCollect(
colTest,
{
Date: Today(),
Location: txtLocationHeader.Text,
Item: "Station 1 CPU",
Status: If(
selectK1121_S1_SystemChecked_btn.Value,
"Checked",
"Not Checked"
)
},
{
Date: Today(),
Location: txtLocationHeader.Text,
Item: "Station 1 CPU",
Status: If(
selectK1121_S1_SystemUpdated_btn.Value,
"Updated",
"Not Updated"
)
}
)

Note: I used the above code with the Patch as you have it and it worked for me.  The only difference is I was Patching a collection and not a spreadsheet, so I think this may give you what you need.  Fingers crossed 🙂

[gbach2290]

I think i got the error's fixed. Some dummy forgot to close his brackets after the Status. 🙄

[subsguts]

I swear those **bleep** gremlins 😂

[gbach2290]

If I've said it once, I've said it a hundred times.... "the devil is in the details".  Thanks for your help!