Unanswered

looping through items in a List

(0) Share

Report

Posted on by Community Power Pla...

looping through items in a List but instead of sending out an email for each list item that meets the condition, collect up the list item data and send out one email at the end. So if a list has 5 items that meet the condition, don't send out 5 emails, send 1 email that says "you have the following 5 items to work on".

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

ryleybauer 327 on at

Like (2)

Report

Use the "Initialize Variable" step at the beginning to create an Array. You'll probably have to create one for each of your conditions unless you reset it mid-flow.

Each time you hit the condition, instead of an email step, use the "Append to array" step.

Then at the end, send your email with the respective array in the body.
If you want, you encapsulate it in a "String()" function and also use a "sub()" function to replace quotes and square brackets if you don't like the array formatting.

Please mark as solution if this helps your issue.

Was this reply helpful? Yes No
Verified answer

David- 1,254 on at

Like (2)

Report
I just set something like this up today. I needed to go through a task list of assignments to our attorneys and send them a summary of outstanding tasks each Friday afternoon. This is how I built it:
Start action Occurrence each Friday
Initialize variable of array type named Emails with the value of: e.g., [ "email1@company.com","email2@company.com", "email3@company.com" ]
Initialize variable of type integer named Count with an initial value of 0 (zero)
Compose action with the input being the output of step 2 above (I probably didn't need this, but it works)
Apply to each action with the output of the compose action in step 4
Get items action set up for the list where you want to pull data
The filter will be the people field in your list that you want to pull items for along with any other criteria.
For me, the filter is: AssignedTo/EMail eq 'Current item' and PercentComplete eq 0
Note: Current item is from in dynamic content under apply to each
Set variable action for the Results variable with the expression length(outputs('Get_items')?['body/value']) as the value
Condition action where Results variable is greater than 0 (zero)
If yes the value being the output of the above Get items action and configure for the fields you want to return:

Create html table action from the output of the above Select
Send an email (V2) action with the output of the Create html table action.
It is hard to read, but the workflow looks like this:

Was this reply helpful? Yes No