Extremely Slow patch using onedrive and excel

[wsalling]

I have a very simple test i am running.  i have a collection that has 1800 rows of data.  i am patching this collection to an excel sheet on oneDrive.  Currently is processing the data at about 1 row every 3 seconds.  Is this normal speed? Seems exremely slow.

Internet speeds are 500 down and 50 up. i have a label set to show countrows(colCounter) to show progress.

colTest has 1800 rows of data.

Forall(colTest,Collect(colCounter,Patch(.......)))

[Pstork1 · Accepted solution]

Using a ForAll with an Excel table that is a relatively typical speed for a table that large.  You might want to look into passing the collection to a flow to do the patching.  ForAll() isn't a particularly efficient process since it has to evaluate each record in the collection before doing the process.  In a flow you would have an Apply to Each loop, which can be more efficient.

[wsalling]

Thanks for the help.. Would be able to point me direction of samples or tutorials? in mean time i will see what youtube has.

thanks again. Took hour an 30 mintues by the way.

[wsalling]

I tried to add Excel for Business but get this error

"Unable to process template language expressions in action 'Add_a_row_into_a_table' inputs at line '1' and column '2665': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_excelonlinebusiness']['connectionId']' cannot be evaluated because property 'shared_excelonlinebusiness' doesn't exist, available properties are ''. Please see https://aka.ms/logicexpressions for usage details.'."

Flow is simple enough, get variable from Powerapps as Json, parse Json, the add to table. ideas?