question

LewisKelly-5950 avatar image
0 Votes"
LewisKelly-5950 asked JerryXu-MSFT commented

Is the Create CSV table process limited to 100 lines?

I am trying to list all the files in a SharePoint directory but the CSV file output seems to be limited to 100 lines when using Power Automate. Is there a setting I'm not seeing that can allow for more lines?

office-sharepoint-online
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @LewisKelly-5950 ,

How is everything going? Is there any update?

0 Votes 0 ·

1 Answer

JerryXu-MSFT avatar image
0 Votes"
JerryXu-MSFT answered

Hi, @LewisKelly-5950 ,

I tested in my end, the create CSV table export a table over 150 rows (150 in the test). AFAIK, the maximum size of the result will be '209715200'. Would you like to double check the Flow setup?

For the action I assume you are using now (Get Files). There is a field called Top Count which determines the total number of entries to retrieve. Have a check on the settings like the screenshot below.

80988-image.png

And you can check each run of the flow, all the data used in every action will be displayed for troubleshooting. Here is a video for your reference.
Similarly it is simple for you to review each action in your flow, ensure whether all the files are retrieved or not. Trace the data flow in every step in the flow. And if you do not have much progress, please share us with screenshots of your flow with detailed setup if possible.

Feel free to reply with any update.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


image.png (32.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.