Answered

Sending Email based on a filter array is creating an 'Apply to each' option that I don't want

(0) Share

Report

Posted on by SteveODea

Hi there, I am having difficulty in send emails based on a filter array. The problem I have is that when I create the send email option, Power Automate automatically puts this into another 'Apply to Each' box which I do not want to happen. I simply wish to send one email, based on each row of the filter array.

I know that I need to type something in specifically when selecting the email itself, but am unsure of the code.

Any help welcome.

I have created an Apply to each step, but when I create the send email step and insert the email address I need, it automatically pops that into ANOTHER Apply each step, which I do not want.

How should the email be written to prevent this from happening?

The current code for the email says items('Apply_to_each')?['TestEmail'], which I think is causing the problem

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @SteveODea ,
inside the first "Apply to each" control you can add a "Compose" action in which put the following expression:
item()['<your_value>']
where replace "<your_value>" with the the TestEmail dynamics content.
Then in the "Send an email" action, you can put the Compose outputs in "To" field.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@SteveODea

You Flow could be much less complicated assuming that the column on which you are filtering is not a calculated column.

You could use a filter query in your Get Items action and simply loop through the output.

Here is a great reference on using a filter query.

Was this reply helpful? Yes No
SteveODea 72 on at

Like (0)

Report
Copy link

Link copied!

n

Was this reply helpful? Yes No
SteveODea 72 on at

Like (0)

Report
Copy link

Link copied!

Sadly, the item on which I'm filtering is a calculated column so need to take the more complicated route

Was this reply helpful? Yes No
SteveODea 72 on at

Like (0)

Report
Copy link

Link copied!

Many thanks @MarconettiMarco that worked. Quirky little solution and still not sure why this is required, but I'm not a coder, but I'll keep that one up my sleeve for next time

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@SteveODea

Since it is a calculated column, the solution suggested by @MarconettiMarco should work well for you. Just use the item() expression followed by the column name in your send an email action. The Compose action is just a way to illustrate the point...

Was this reply helpful? Yes No
SteveODea 72 on at

Like (0)

Report
Copy link

Link copied!

Many thanks

Was this reply helpful? Yes No