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.
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.
------------------------------------------------------------------------- If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up.
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.
------------------------------------------------------------------------- If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up.
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?
