web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Doing mail merge - can...
Power Automate
Unanswered

Doing mail merge - can Power Automate handle a very large Excel?

(0) ShareShare
ReportReport
Posted on by 64

I would like to do a mail merge in which I am generating letters in DOCX or PDF format. However, the data source is an Excel file with about 20 000 records.

 

Can Power Automate handle such a large Excel? I've read somethings about a limitation of 250 records with the List Rows action.

Categories:
I have the same question (0)
  • DJ_Jamba Profile Picture
    2,837 Super User 2025 Season 2 on at

    Hi @tomswaelen 

     

    I wouldn't recommend this at all because there are so many things you would have to consider including mailbox limits, api connection limits and the number of batches you would have to do to get through 20K rows, plus many other things....

     

    For now, yes the limit is 256 I think, but if you click on the 3 dots in the List rows excel action you can increase pagination:

    - to 5000 in an automated/scheduled flow.

    - you may be able to increase it to 10K or 20K if it's a manually started flow (not 100% sure on this one)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard