cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Performance Issue with Patch

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

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: Performance Issue with Patch

Hi @JasonF ,

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.

Highlighted
Helper III
Helper III

Re: Performance Issue with Patch

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

Highlighted
Community Champion
Community Champion

Re: Performance Issue with Patch

Ok thanks,

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

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!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,356)