I am creating a flow to email a newsletter using Power Automate in Office 365. I am a very beginner.
There are about 3,000 recipients and due to server reasons, I need to split them into 250 groups and also give them an hour after each send.
I found this flow but I want to add the process to copy and paste every 250 items from the list and send emails every an hour until the end.
https://rishonapowerplatform.com/2021/10/15/using-apply-to-each-control-to-perform-mail-merge-with-power-automate/
Copy 250 email addresses from the list (excel file) on Office 365
↓
Paste them to BCC
↓
Send emails
↓
Pause an hour
↓
Copy another 250 email addresses from the list
↓
repeat....until the end
Hope someone kindly suggests a solution.
