Splitting an array

(0) Share

Report

Posted on by annetoal

1,934 Moderator

Hello:

I have an array that looks like this:

[
 "email_1@domain.edu",
 "email_2@domain.edu"
]

I would like to split it into an array with two rows. One address per row. Could someone please show me how to do that? @Pstork1

Thank you,

Anne

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
I'm not sure what you are trying to do. If its already an array its already two rows. But if its a string. Try the following

split(substring(Inputarray,1,sub(length(Inputarray),2)),',')

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

Hi @annetoal ,

Considering you are already having an array and you would want to do some processing on this data, please try to use Apply to each which acts as a loop

in the input of this loop please use your array variable as I have used Test Array.

Thanks

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report
I didn't explain myself very well. I am trying to
1. walk through the list of emails and find all files that are associated with each email.
2. Make a html table of all the files associated with each email address.
3. Mail each address in the list with a mail that contains the table of all the documents mentioned in 2.

@Pstork1 @ManishJain Problem is the code is not looping correctly. Sending a mail to the output of that array yields this address line:
["email_1@domain.edu","email_2@domain.edu"];
I don't want to mail both at once; I need to mail each one separately. I concluded that splitting the array into two rows would let the apply to each step walk through the list of emails one at a time. Was that reasoning flawed?

Using Split on an array results in an error. Please advise.

If it helps, here is the current code. A Terminate has been inserted to speed up testing--it will be deleted later. Notice the ODATA filter query and sort in the properties step.
Many thanks for any help,
Anne

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

The key here is to sort the input by email, then once you've found all the records for the first email , create the table and send the email. You can do that by saving the last email processed and checking whether a new row matches it. If it does keep processing, if it doesn't send the email. Don't store the output until everything is processed. Send it periodically.

I just went through a similar scenario with another post. Here's the thread. If you look at my responses you will find a full sample with screenshots towards the bottom.

Re: Ignore duplicate email addresses when sending ... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Thanks, that clarifies things considerably. I will try to create that. If you by chance have any sample code you could share, that would give me a basis to work from. All assistance gratefully received.

Thank you,
Anne

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Sample code is all in the screenshots on that post.

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Like Socrates' "the answers are within you." Okay, I'll go back to my nonworking code. Thanks again.

a

Was this reply helpful? Yes No