Filtering an array

(0) Share

Report

Posted on by annetoal

1,934 Moderator

An array that looks like this is the output of a select operation on the properties of a SharePoint library.

[
 {
 "Reviewer": "user.1@school.edu",
 "Filename": "file1.docx",
 "Reviewdue": "2021-11-17"
 },
 {
 "Reviewer": "user.1@school.edu",
 "Filename": "file2.docx",
 "Reviewdue": "2021-11-17"
 },
 {
 "Reviewer": "user.2@school.edu",
 "Filename": "file 3.docx",
 "Reviewdue": "2021-11-17"
 }
]

The array is the output of Select that has been sorted and stored in an array called sorted. Sorted has a length of 148.

An array variable called uniqueEmails is a union of the "Reviewer" item from the output of Select, producing a list of unique emails. uniqueEmails has a length of 20.

union(body('Select_emails'),body('Select_emails'))

Now, I need to make a HTML table for user.1 showing the 2 Filename and Reviewdue entries.

(Then the HTML table will go into an email addressed to the Reviewer address.)

Then, I want to make a HTML table for user.2 showing the 1 Filename and Reviewdue.

And so on sending an email and then looping through the list of uniqueEmails until the end.

Item is

item()

Reviewer is

body('Select_emails')?['Reviewer']

Please help. This runs indefinitely and never finishes.

Thanks,

Anne

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
You should only need the main Apply to each for the unique emails, and within that just have a:
Filter array
Create HTML table
Send email
You don't need the two inner loops.

So, for the first email it will filter the results by that email. You then create an HTML table from the Filter array. And finally send an email to that person with the HTML table in the email.

The Filter array would use the output of sorted as its input, and you would then have the condition using:
item()?['Reviewer'] Equal to Current Item from your Apply to each.

I've created an example. The full flow is below. I'll go into each of the actions.

Initialize variable sorted contains your array of JSON data.

Select gets each of the Reviewer (emails) using the expression:
item()?['Reviewer']

Initialize variable unique emails uses a union to get unique emails.
union(body('Select'),body('Select'))

Apply to each iterates over each of the unique emails:

Filter array usings sorted as its From and uses the expression for the Reviewer email.
item()?['Reviewer']
is equal to
Current Item from the Apply to each. This will get the current email.

Create HTML table uses the Body from Filter Array. I've just used Automatic Columns in this example.

Send an email will then send an email to the current email address (Current item from Apply to each) with the embedded HTML table.

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

Like (0)

Report
Copy link

Link copied!

Thank you very much!

Was this reply helpful? Yes No