Answered

Power automate send email using excel file for receipients(by batch)

(0) Share

Report

Posted on by jaredamul27

Hi Guys,

I am creating a auto sending of email for a list of recipients that is listed in a excel file. We have a requirements to send first for 10 email address then wait 5 mins then send to the next 10 email address on the list. I am having a problem on the "Do Until Loop" to get the list of email address and how to set it only by 10's

10 emails

wait 5mins

|
10 emails

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report

Hi @jaredamul27 ,

I've made a test for your reference:

1\My Excel table

2\My flow

1)

div(length(outputs('List_rows_present_in_a_table')?['body/value']),10)

2)
take(skip(outputs('List_rows_present_in_a_table')?['body/value'],mul(variables('Count'),10)),10)

3)
items('Apply_to_each')['recipients']

Best Regards,

Bof

Was this reply helpful? Yes No
jaredamul27 5 on at

Like (0)

Report

@v-bofeng-msft

Thank you soo much it is now working and follows the rules

Was this reply helpful? Yes No