Patching collection back to datasource

(0) Share

Report

Posted on by nick9one1

353

I have a dataverse table that I'm trying to manipulate data in, but its not working, the patch does not give an error, but it does not patch.

I have two buttons and a text box.

Button 1 - this works and gets a local collection

ClearCollect(
    currentSubmissions1,
    Filter(
        ELT_PA_Inputs,
        Month = monthCounter && Year = yearCounter && Domain = PageTitle
    )
);

textbox on change value; -this works and changes the value in the local collection

Patch(
    currentSubmissions,
    LookUp(
        currentSubmissions,
        Domain = PageTitle && TileName = MetricTitle_5.Text && Metric = "Actual"
    ),
    {Value:Value(Self.Text)}
)

the final stage is trying to patch the collection over the data source. There are some values it does not let me patch (modified, created, etc.) so I have used show columns to select only the columsn I need to update;

Patch(
    ELT_PA_Inputs,
    ShowColumns(
        currentSubmissions,
        ID,
        Value,
        Commentary
    )
);

there is no error, but the data does not change. What am I doing wrong?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@nick9one1, Can you please try this and revert me.

ForAll(

    currentSubmissions,

    Patch(

        ELT_PA_Inputs,

        LookUp(ELT_PA_Inputs, ELT_PA_Inputs = ThisRecord.ELT_PA_Inputs), // if Dataverse row ID is stored

        {

            Value: ThisRecord.Value,

            Commentary: ThisRecord.Commentary

        }

    )

)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
nick9one1 353 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks. I'm struggling to make that work;

These are the two columns that have ID and GUID

Collection:

I notices that powerapps changes the column names to include cr20b on the collect.

dataverse:

Was this reply helpful? Yes No
nick9one1 353 on at

Like
a
(0)

Report
Copy link

Link copied!
this seems to work, and patch the data source correctly.

ForAll( currentSubmissions, Patch( ELT_PA_Inputs, LookUp(ELT_PA_Inputs, ID = ThisRecord.ID), // if Dataverse row ID is stored { Value: ThisRecord.Value, Commentary: ThisRecord.Commentary } ) )

Obviously a bit slow

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Try below :

ForAll(
currentSubmissions,
Patch(
ELT_PA_Inputs,
LookUp(ELT_PA_Inputs, ID = currentSubmissions[@ID]),
{
Value: Value,
Commentary: Commentary
}
)
)

Was this reply helpful? Yes No
nick9one1 353 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, That also works. But 'ForAll' is very inefficient and slow.

Do you have any idea why my original patch statement doesn't work? It's using the exact same fields.

Patch( ELT_PA_Inputs, ShowColumns( currentSubmissions, ID, Value, Commentary ) );

Was this reply helpful? Yes No
Suggested answer

SebS 4,826 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@nick9one1

By using show collumns you braking metadata (stripping it off) what is required for Patch processing Batch logic behinde the scen

Patch( ELT_PA_Inputs, currentSubmissions );

It would be quicker if you just use this aprouch and check if it will work for you

Was this reply helpful? Yes No
nick9one1 353 on at

Like
a
(0)

Report
Copy link

Link copied!
I cant do that as the table has columns that cant be changed (e.g. modified by, and modified).

If I do this;

Patch( ELT_PA_Inputs, currentSubmissions );

I get this error;

Was this reply helpful? Yes No