cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mohaimen88
Regular Visitor

Powerapps very slow to patch to sharepoint list

Hi All, 

 

I'm building a timesheet app for my company and facing a delay/latency issue with submitting to sharepoint list. here's how my app is built:

1. I'm pulling a full list of workers names, IDs, etc from a sharepoint list to a collection 

2. using a gallery to  update the collection with regular hours/overtime and presence status for each worker. 

3. a save button with patch command to patch the collection to a sharepoint list. 

 

the problem I'm facing is the app is taking 2-5 min to submit the collection (about 50 lines), and if the user exit the app before it finishes uploading the data, the process will not complete... Please help. thank you 

 

Mo.

3 REPLIES 3
Community Support
Community Support

Re: Powerapps very slow to patch to sharepoint list

Hi @mohaimen88 ,

Could you please share more details about the formula you used in your app to patch collection to your SP List?

 

Actually, there are many reasons that an app can be slow to load, slow to respond, and slow to write to data sources. Please check the performace suggestions in the following blog:

https://baizini-it.com/blog/index.php/2017/09/13/powerapps-improving-app-performance/

 

If you want to patch a collection back to your SP List, the standard formula as below:

ForAll(
       Collection1,
       Patch(
               'YourSPList',
                LookUp('YourSPList', ID = Collection1[@ID]),
                {
                   Column1: Collection1[@Column1],
                   Column2: Collection1[@Column2],
                   Column3: Collection1[@Column3],
                   ...
                }
       )
)

 

In addition, please mak sure the Network on your side is in a good condition and the available RAM is enough on your PC. The Network state and available RAM would also affect the data process in your app.

 

Please also check if the following performance tips for canvas app would help in your scenario:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/performance-tips

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mohaimen1988
New Member

Re: Powerapps very slow to patch to sharepoint list

Thank you Kris, I tried the threads you sent with no luck. 

 

here's the formula I'm using: 

ForAll(ColLabor, Patch(TS_LIST, Defaults(TS_LIST), 
{
    TS_LABORNAME: L_LaborName,
    TS_LABORNUM: L_LaborNumber,
    TS_PROF: L_Prof,
    TS_PROJECT: L_Project,
    TS_REGHOURS: L_Hours,
    TS_OTHOURS: L_OT,
    TS_HOLIDAYHOURS: L_Holiday,
    TS_REMARKS: L_Remarks,
    TS_DATE: F_Date.SelectedDate,
    TS_CreatedBy: DD_CreatedBy.Selected.Title,
    TS_ABSENT: L_Absent
})),

 

Thank you 

Mo

Super User
Super User

Re: Powerapps very slow to patch to sharepoint list

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,777)