Power Platform Community Forum Thread Details

Hi everyone, I'm pretty new to the Power Platform space and have been working on a POC for a customer which uses Dataverse tables. For context, I'm trying to essentially copy and paste data to and from my data source. The rows could be anywhere between 1-300 rows.

This is what I do:

I first put the table into a collection and specify the columns that I want to collect using show columns.

Because I want to create new rows, I exclude the id column from my collection.

ClearCollect(colTable, ShowColumns(datasource, column1, column2....etc))

I then patch the entire collection to my datasource.

Patch(datasource, colTable)

For reference, I have a table that shows me the rows that I've copied and pasted over and what I've noticed is if I've patch for example 70 rows - 60 or so rows will be patched instantly, and then after 5+ minutes Power Apps patches the remaining rows.

What's even more strange, was that before last Thursday - it was patching 100, 200 rows within 6-12 seconds with no issues. Has anyone experienced this behaviour?

I've attached an image of my table data - first column is just a string column, second column is "created date".