Unanswered

Performance Issue with Patch

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I have created a inventory app on PowerApps. Part of this app has the ability to created different templates for different locations. Once a template is created I use the Patch command to generate a inventory for the user to completed his inventory. The following is that patch command:

ForAll(
 'Template Details',
 If(
 crdf5_TemplateNo.TemplateNo = TempNo,
 Patch(
 'Inventory Details',
 {
 crdf5_Category: crdf5_Category,
 crdf5_ItemNo: crdf5_ItemNo,
 crdf5_itemdescript: crdf5_itemdescription,
 crdf5_inventoryunits: crdf5_Units.'Unit Type Cal',
 crdf5_unitqty: crdf5_UnitQtyCal.'Unit Qty',
 crdf5_InReportNo: LookUp(
 'Inventory Reports',
 Text(InReportNo) = DataCardValue4.Text
 ),
 crdf5_purchasecost: crdf5_purchasecost
 }
 )
 )
)

Considering we are patching about 300 record this process can take a long time (3min). Can any of you see a way I can performance tune this, or suggest a different approach?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,
I am not an SQL user and just wanted to confirm these are new records.
If so, you can consider using the Collect command as this works in SharePoint
The field names of the Collection would have to be the exactly the same as ones in the data source (some RenameColumns may be necessary) and the syntax for SharePoint is simply
Collect(‘Inventory Details’,’Template Details’)
This might be worth testing for speed if it works in SQL.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Warren,
I did not think that your could "collect" from one CDS table to another. I will do some tests and let you know hat this works.

Jason

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Ok thanks,
You are probably right with the tables - what about a collection to CDS?

Was this reply helpful? Yes No