You’re offline. This is a read only version of the page.
Announcements
Hello, I am new to using PA, I followed a video guide on creating a flow to send multiple emails each with a different attachment and a list of BCC addresses.
How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments - YouTube
The flow works for small numbers of emails. I had an Excel sheet of 23 emails to send out that successfully sent (after enabling Pagination on List Files in Folder and raising the threshold). However, I then did it again with a list of 90 or so with 70 additional emails BCCed somewhere in there (raised the threshold to 1000 to be safe), and I received a message about my flow being throttled as below:
Alert: Your operation has been throttled.
Mailmergetestfile started experiencing issues at 22:13 ,12/6/2022 UTC
What happened?
Looks like your flow's operation is hitting an action limit designed to protect the connector service being called.
Then I checked my analytics for the flow and found that the List files in folder step is taking up the most time and I assume is why it was throttled in the first place. I am aware the Pagination option also causes issues, but I needed the threshold raised to send it to all the emails. I have since lowered it to 200 but I don't know if that will hold for the future so I am exploring other options now.
Are there alternatives I can use besides this to achieve the same effect? I have an Excel sheet with each row having a file name to send and an email to send it to, with the List action being used to take those named files from the folder.
Furthermore, I wanted to know how I could add an additional step, to produce lists of what emails were valid and what emails were not. It bounces back if the email couldn't be sent, but I was hoping to get a single list instead of checking through every bounced email.
Share
Report
All responses (
Answers (
245
