web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Is there a maximum num...

Power Automate - Building Flows

Unanswered

Is there a maximum number of rows with "add a row into a table" of a Share Point File?

Like (0) Share

Report

Report

Posted on 10 Nov 2023 22:01:28 by Sarah2626

9

Is there a maximum number of rows with "add a row into a table" of a Share Point File?

I keep reading about maximum rows with "get files," but that is not what I am using.

Thanks. I am still very new to Power Automate and flows.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

grantjenkins 11,059 Moderator on 10 Nov 2023 at 23:06:06

Like (1)

Report
Re: Is there a maximum number of rows with "add a row into a table" of a Share Point File?

I don't believe there is a limit using Add a row into a table since you would be adding individual rows (potentially within an Apply to each). The issue you would face is how long it would take to add a lot of rows.

Get files and Get items (SharePoint) both return the first 100 items by default. List rows present in a table (Excel) will return the first 256 rows by default. If you wanted to get more rows you have a couple of options.

If you know you have less than 5000 rows you can just set the Top Count to 5000 so it will return up to 5000 items.

If you may have more than 5000 rows, you would need to go into the Settings of the action and turn on Pagination then set the Threshold to something higher than the number of rows you have - this would then return the rows in batches up to the Threshold. From memory, the max limit for Threshold is 100000.

How many rows were you looking to add into your Excel Table?

Was this reply helpful? Yes No
trice602 14,707 Super User 2025 Season 2 on 11 Nov 2023 at 02:06:36

Like (1)

Report

Re: Is there a maximum number of rows with "add a row into a table" of a Share Point File?

Hi @Sarah2626 ,

Also consider using office scripts which is very fast and stable.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 666 Super User 2025 Season 2

#2

Tomac 382 Moderator

#3

developerAJ 254

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans