row limit for adding data from excel to sharepoint through power automate

Question

Please let me know what is the row limit to add data from excel to sharepoint list?

[the max number of rows in excel that can be uploaded to the SPlist ]

Answer 1

Dear respected Shravyashree Shetty,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, using Power Automate "List rows present in a table" action, the Power Automate can handle up to 256 rows per request by default. The max limit of rows which we can retrieve is limited by default at 256.  In order to increase this limit and retrieve more rows we can enable the pagination and then retrieve the next batch in Power Automate(for your reference: 256 rows limit - Power Platform Community).

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

Hi respected Shravyashree Shetty,

I'm writing a follow up this case, and I haven’t received any information from you, may I know have you checked above reply? Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad

Answer 3

Hi Muhammad, do you know what's the max number we can set the pagination?