Share
Report
8Hello everyone, I've created a Power Automate flow that converts a CSV file, extracted from my Power Apps app, into an Excel file on SharePoint.
The problem I'm facing is that when the number of rows in my CSV is very large, the flow takes more than 2 minutes, and it ends up failing, displaying an error, and doesn't return the download file I need.
Here’s how I’m currently doing it:
I create the Excel table and then use an 'Apply to Each' loop where, for each row in my CSV (take(skip(outputs('Compor_2'),1),400)), I use the 'Add a Row into a Table' action to insert each one into the Excel file I’ve created. This is the part of my flow that takes a long time. For small amounts of rows (20-50), it works perfectly, but for 100+ rows, it starts taking around 5 minutes to execute. In my worst-case scenario, I’ll have a maximum of 300 rows.
How can I speed up this conversion process so it doesn't take so long, either by using these connectors or finding a specific (non-premium) connector that can handle this conversion? I tested 'Plumsail,' but I'm not sure if it works without payment, even though it’s not listed as premium.
If anyone knows how to accelerate this conversion flow, I’d really appreciate the help. Thank you very much!
All responses (
Answers (
