why i cannot patch the collection ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

This is the error i get:

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

PPDEV 142 on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous,

Can you provide your "Patch" code? So we could take a look where you're error coming from? But upon checking the issue provided in the screenshot, it seems like you are missing the "Defaults" expression in the patch.

The structure should look like this:

Patch( DataSource, Defaults(DataSource), // Specifies the record to update or create if it doesn't exist { // Column-value pairs to modify or create Column1: NewValue1, Column2: NewValue2, // ... } )

Thank you!

Please consider accepting my solution if it has resolved your issue, as it can help others with similar problems.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Patch(colKapas; {Mitarbeiter:DataCardValue15_8.Text; Kapazität:TextInput3_3;Monat: DataCardValue17_8.Selected.DateMonthYear})

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous , Can you please elaborate where you get the error?
What are you doing?
Is there any flow involved?
Does the flow is triggered from PowerApps?
As the error message which I believe in Germán language says that "The data source passed to the function is invalid", so what is the data source?

Make sure that the schema of the source and the collection must match.

Please help us with the background of the issue because we cannot see your screen.
-----------------------------------------------------------------------------------------------------------------------------
I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

No there is no flow, the data source is a collection

Was this reply helpful? Yes No
PPDEV 142 on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous, please try this:
Patch( colKapas, Defaults(colKapas), // This line initializes a new record with default values { Mitarbeiter: DataCardValue15_8.Text, Kapazität: TextInput3_3.Text, Monat: DataCardValue17_8.Selected.DateMonthYear } )

Thank you!

Please consider accepting my solution if it has resolved your issue, as it can help others with similar problems.

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI @Anonymous , Please check what @ppDev_30 is suggesting. Defaults is required when you want to create new record and use LookUp function if you want to update existing record.

Thanks,
ANB

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

same error !

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

i do not want to create a new record , i want to edit one

Was this reply helpful? Yes No
PPDEV 142 on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous, if you want to update an existing record, you should change the "Defaults" to "LookUp", something like this:

Patch( colKapas, LookUp(colKapas, ID = ThisItem.ID), // Please update the source on this line { Mitarbeiter: DataCardValue15_8.Text, Kapazität: TextInput3_3.Text, Monat: DataCardValue17_8.Selected.DateMonthYear } )

Thank you!

Please consider accepting my solution if it has resolved your issue, as it can help others with similar problems.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

no it is a gridable gallery like here:

and still the same error !

Was this reply helpful? Yes No