
Announcements
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".
hi there,
It is normal issue.
Sometimes it performs great, but sometimes it performs so slowly.
Power apps is unstable currently, maybe something related to the server cause this issue.
Move on if this does not affect your app.