cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RS
Level: Powered On

Add / Remove record from excel table takes ages

I have a button that uses UpdateContext (populated by 2 dropdowns) and then SubmitForm to add a new record to an excel table stored in OneDrive , and another that removes the currently selected record. The thing is, either of these actions takes 15-20 seconds to complete, and sometimes seems to just time out without a message. Am I doing something wrong or is this expected behaviour?

 

Thanks in advance for any help offered.

 

2 REPLIES 2
hpkeong
Level 10

Re: Add / Remove record from excel table takes ages

Hi  @RS

 

As of my experince and @Mr.Dang, we have tested OneDrive, DropBox and GoogleDrive, so far,

only DropBox can response within 3-5 seconds.

OneDrive and GoogleDrive can go for about 20-50 seconds.

 

You are not wrong but have chosen a slow response cloud storage service platform.

We have no idea why OneDrive and Google Drive is Slow but frankly, Dropbox is almost par with CDS.

 

Please have a trial.


TQ 

hpkeong
RS
Level: Powered On

Re: Add / Remove record from excel table takes ages

Thanks for the tip, I'll give it a go. Frankly it is beyond absurd (but not really surprising) that I have to go outside of the microsoft ecosystem to get decent data link performance.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (5,420)