Unanswered

What is the current limitation Power Automate have to import data from Excel to SharePoint List?

(0) Share

Report

Posted on by PratikD21

Hi,

What is the current limitation Power Automate have to import data from Excel Table to SharePoint List? How may writes can happen?

Also, how many rows can read from Excel Table? Is it possible to read more 5000 rows?

Any link associated with this link would be better.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

yashkamdar 1,044 on at

Like (0)

Report
Copy link

Link copied!

Hello Team,

There are some limitation when it comes to exchanging data between Excel and SharePoint List.

If you are thinking of importing data from Excel to SharePoint via Power Automate then you will need to Parse the entire excel sheet data and this cannot happen in one go, you will need to parse the data in batches.

You will need to implement pagination too.

Please refer to the blog post below which will help you achieve this in the right way going forward-

Blog post - https://piyushksingh.com/2020/07/06/power-automate-read-excel-file/

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
PratikD21 38 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for your response. Are there any details on the requested information?

Thanks.

Was this reply helpful? Yes No
yashkamdar 1,044 on at

Like (1)

Report
Copy link

Link copied!

Hello Team,

Yes, the information that I just shared should answer all your queries.

Let me answer point by point -

What is the current limitation Power Automate have to import data from Excel Table to SharePoint List? How may writes can happen?
There isn't any limitation as such, you can go ahead and process a very big Excel file too but it may take a lot of time.
Large tables take long to load. (4000 rows takes about 2 minutes)

There are different approaches mentioned here to reduce the time-
https://medium.com/@anoopt/different-ways-of-getting-excel-data-using-power-automate-e21292b1d02a

Also, how many rows can read from Excel Table? Is it possible to read more 5000 rows?
Yes, absolutely possible but make sure you do this in batches and implement pagination as per the blog post I sent you earlier.

I hope this answers all your queries.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No