Is the Create CSV table process limited to 100 lines?

Lewis Kelly 1 Reputation point

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?

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,456 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Jerry Xu-MSFT 7,796 Reputation points

    Hi, @Lewis Kelly ,

    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.


    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.