cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,957)