Auto splitting concat emails into different batches

(0) Share

Report

Posted on by Majingcth

I have a collection with emails as below:

1@yahoo.com

2@yahoo.com

3@yahoo.com

4@yahoo.com

5@yahoo.com

6@yahoo.com

7@yahoo.com

8@yahoo.com

9@yahoo.com

1@yahoo.com

2@yahoo.com

3@yahoo.com

4@yahoo.com

5@yahoo.com

6@yahoo.com

7@yahoo.com

8@yahoo.com

9@yahoo.com

10@yahoo.com

I have a label concat these email into below, which targets to send out a single email.

The number of emails will vary, and I would like to split the concat emails into different batches in Power Automate, such that total 5 emails will in 1 batch. Is there any good idea to achieve this?

1@yahoo.com;2@yahoo.com;3@yahoo.com;4@yahoo.com;5@yahoo.com;6@yahoo.com;7@yahoo.com;8@yahoo.com;9@yahoo.com;10@yahoo.com

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Hi @Majingcth ,

If you want to send an array to Power Automate flow you will need the JSON() function on Power Apps app side and a Parse JSON action on PowerAutomate.

Here is a short example of PowerApps code, starting from your request:

ClearCollect( Mails, Split( "1@yahoo.com;2@yahoo.com;3@yahoo.com;4@yahoo.com;5@yahoo.com;6@yahoo.com;7@yahoo.com;8@yahoo.com;9@yahoo.com;10@yahoo.com;11@yahoo.com",";" ) ); ClearCollect( MailsSplitBy5, With({rows:CountRows(Mails)}, ForAll( Sequence(RoundUp( rows/ 5,0)), With( { Last5: LastN(FirstN(Mails,5 * Value),If(Value>RoundDown(rows/ 5,0),Mod(rows,5),5)) }, Concat(Last5,Result & ";") ) ) )); Set(JSONforFlow,JSON(MailsSplitBy5))

Hope it helps !

Was this reply helpful? Yes No
Majingcth 47 on at

Like (0)

Report
Could you provide a little bit explanation on below code.

ClearCollect( MailsSplitBy5, With({rows:CountRows(Mails)}, ForAll( Sequence(RoundUp( rows/ 5,0)), With( { Last5: LastN(FirstN(Mails,5 * Value),If(Value>RoundDown(rows/ 5,0),Mod(rows,5),5)) }, Concat(Last5,Result & ";") ) ) ));

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
@Majingcth ,

So

With({rows:CountRows(Mails)}

rows is a temporary value used inside with () function (i prefer not to repeat same function call like CountRows() here)

ForAll( Sequence(RoundUp( rows/ 5,0)),

I calculate the number of batches of 5 items using RoundUp( rows/ 5,0).

Sequence() function create an array of numbers from 1 to .... max number of batches.

And ForAll iterates through resulting array to obtain a table.

With( { Last5: LastN(FirstN(Mails,5 * Value),If(Value>RoundDown(rows/ 5,0),Mod(rows,5),5)) }, Concat(Last5,Result & ";") ) )

I took batch of 5 by batch of 5 and create a item in table.

Was this reply helpful? Yes No
Majingcth 47 on at

Like (0)

Report

Thanks for the guidance, will give it a try.

Was this reply helpful? Yes No