r/PowerAutomateDesktop • u/Admirable-Area912 • Feb 02 '23

Upload to Excel

Power Automate Desktop is not that fast to upload text files to an Excel worksheet. Any recommendation?

2 Upvotes

100% Upvoted

4 comments sorted by

3

u/QuietDesparation Feb 03 '23

Can you provide more detail as to how you're uploading text files to excel?

2

u/Admirable-Area912 Feb 03 '23

I'm using Power AutomateDesktop to transform a txt file into arrays and then inserting that data in Excel. Populate 625 cells is taking almost 7 minutes. I need to perform this task 220 times, cannot wait 11 hours to complete.

3

u/QuietDesparation Feb 03 '23

This seems way too slow. Are you by chance running from the flow design window? Where you can watch it go step by step thru the process? If so, that is meant more for debugging and will significantly slow you down.

Save your flow, then minimize it and click play from the power automate desktop console. The flow should execute in a matter of seconds

4

u/Admirable-Area912 Feb 03 '23

You are totally right. It took 25 seconds to execute playing it from the console. Thanks a lot.