why i cannot patch the collection ?

(0) Share

Report

Posted on by Community Power Pla...

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
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... on at

Like (0)

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

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

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... on at

Like (0)

Report

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

Was this reply helpful? Yes No
PPDEV 142 on at

Like (0)

Report
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,223 Super User 2025 Season 2 on at

Like (0)

Report

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... on at

Like (0)

Report

same error !

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

Like (0)

Report

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
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... on at

Like (0)

Report

no it is a gridable gallery like here:

and still the same error !

Was this reply helpful? Yes No