Convert CSV to Excel with Power Automate- CSV file includes a column as description with large text

Aida Vatankhah 1 Reputation point
2022-06-07T13:46:49.047+00:00

Hi,

I have used the following link to create a flow to convert the CSV file to Excel and it works fine for a sample normal csv file! This document uses a Microsoft script for doing so.

https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv?source=docs#power-automate-flow-create-new-xlsx-files

The problem: The CSV file that I need to convert it to Excel has a column as description which includes large text. While running the flow, it stuck in "Running the Microsoft script to convert csv to excel" and finally "Time out".

What is the limitation for content size in csv?
How can I modify the code to support the csv files including cells with large content size? (In my csv file, the number of rows and columns are normal (20 rows and 6 columns), but the content inside one cell can exceed the limited value)

I would appreciate your help in advance!

Regards
Aida Vatankhah

Microsoft 365 and Office Development Office JavaScript API
Microsoft 365 and Office Development Other
Community Center Not monitored
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.