Unanswered

Send email for each filtered Array item and output array value

(0) Share

Report

Posted on by philipremanuel

Hi-

This Flow will run on a daily schedule checking for items that meet certain criteria and then send an email. I have successfully filtered a SharePoint list using chained filter array activities, I probably could've done this using one filter, but I'm fine with this method unless it is causing the problem. I simply want to loop through the filtered result and send an email for each item in the array outputting one value from the resulting filtered array - the 'Project Name.' Currently, I'm using a static email address as the send to, however once this is functioning I will switch the static email to a value stored in the array- 'Assigned to')

Here are the activities I'm performing.

I tried forcing it to loop off of the array output 'item' instead of 'body' and then 'item', but that returned blank values for 'project name' and there are no blank values.

Here is the result from the screenshot above.

I've researched solutions and many of them don't apply to my specific situation or are unnecessarily complex, creating html tables and the like. I would think that looping through a filtered array created from a sharepoint list should be fairly straightforward. Any help would be much appreciated.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

Hello @philipremanuel ,

when you use the 'Filter array' action you should always loop through the 'Body' dynamic content. That's also what the error message tells you, you can't loop through 'Item' as that's only the current item from the 'Body' = object. Not an array you could loop through.

Was this reply helpful? Yes No
philipremanuel 45 on at

Like (0)

Report

Thanks for your response. I made the change to run off of body with a single apply to each. It ran and sent 9 emails which meet the filter criteria as expected. However, the item()?['Project Name'] value displayed as blank when I reviewed the 9 emails. Am I referencing the array incorrectly?

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

Hello @philipremanuel ,

I think the ['Project Name'] is not correct, it should be internal name of the SharePoint column and internal names don't support spaces. The internal name will be something like ProjectName or Project_x0020_Name.

Was this reply helpful? Yes No