cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jsarnold
Level 8

Unable to Patch a Collection

We have several Production Apps (SQL as DataSource) that have not been edited in weeks, that suddenly do not allow Patching a Collection. They give error: Invalid Argument type (Table) Expecting a Record. In my experience this would indicate that the Collection doesn't exactly match the fields of the Table it is attempting to write to; however we haven't edited the SQL server tables/settings or the PowerApp in weeks.

 

On some apps, we were able to get back up by removing the Data Source and re-adding it; however, this only works from within the Dev Studio. As soon as you save/close/re-open the PowerApp, the Error returns.

 

Is anyone else experiencing the issue? 

 

Session ID: f6ca3229-7543-c822-c796-306bc1af0901

1 ACCEPTED SOLUTION

Accepted Solutions
jsarnold
Level 8

Re: Unable to Patch a Collection

No, Patch allows for passing a Colection as well.

 

https://powerapps.microsoft.com/en-us/tutorials/function-patch/

 

The error has since fixed itself in the past few hours. I assume it's from Microsoft updates.

View solution in original post

2 REPLIES 2
VincentM
Level: Powered On

Re: Unable to Patch a Collection

It expects a single row in the patch and your query returns more than 1 row. You could try adding a first() arround the query?

jsarnold
Level 8

Re: Unable to Patch a Collection

No, Patch allows for passing a Colection as well.

 

https://powerapps.microsoft.com/en-us/tutorials/function-patch/

 

The error has since fixed itself in the past few hours. I assume it's from Microsoft updates.

View solution in original post

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 279 members 3,489 guests
Please welcome our newest community members: