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

Like (0) Share

Report

Posted on 27 Mar 2024 18:38:00 by tomswaelen

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.

All responses (1)

Answers (0)

DJ_Jamba 2,832 Super User 2025 Season 2 on 27 Mar 2024 at 21:35:49

Like (0)

Report

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

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)