cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Advocate I
Advocate I

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?

Anonymous
Not applicable

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,387)