Unanswered

Performance Issue with Patch

(0) Share

Report

Posted on by Community Power Pla...

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)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
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... on at

Like (0)

Report

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 153,117 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No