Using Output of Filtered Array in Apply to Each Dynamic Content

(0) Share

Report

Posted on by AK-01121952-0

Hi all,

I have a flow which does List Rows in Table>Filter Array>Apply to Each>Send an Email. I can select Filter Array(Body) as the input for "Apply to Each", but then columns for filtered rows are not available as dynamic content in the email, only columns from the original List Rows step. I've attached a picture of my options for the Send an Email step.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

Use the expression item()?['schemaname']

eg: you column name is emailaddress then

item()?['emailaddress ']

Thanks

Was this reply helpful? Yes No
AK-01121952-0 10 on at

Like (0)

Report
Copy link

Link copied!

@abm abm how does it know which output item()?['emailaddress'] refers to?

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Use items('Apply_to_each')?['propertyname']

Was this reply helpful? Yes No
Suggested answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It all depends what action step you are using next.

You can iterate using an Apply to each

Or without say for example if you are using convert to html or somethin then use item() expression.

Thanks

Was this reply helpful? Yes No
AK-01121952-0 10 on at

Like (0)

Report
Copy link

Link copied!

@abm abm the order is List Rows from Table > Filter Array > Apply to each. But how does it know if I'm using the output of "List Rows" or "Filter Array" when I refer to property?

Was this reply helpful? Yes No
AK-01121952-0 10 on at

Like (0)

Report
Copy link

Link copied!

@Chriddle how will it know if I'm referring to the output of "List Rows From Table" or "Filter Array" ?

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

In your flow are you trying to send email for all the records which you filtered. That means if the filter array contains 10 records you sending 10 emails? Or you want to send one email and put all the contents of the filter array in this send email body.

Thanks

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @AK-01121952-0

It will know because you are specifically defining what the Input is

If you have

List Rows

Then Filter Array

In your Apply to each you are either putting in the body/value of list rows or the output/body of the filter array action, that is how it will know based on the input you give it.

Was this reply helpful? Yes No
AK-01121952-0 10 on at

Like (0)

Report
Copy link

Link copied!

@Michael E. Gernaey I put "Filter array" is the input for "apply to each." But then I had to use the "List rows" dynamic content in the email and it created a separate "for each" loop within the "apply to each".

Was this reply helpful? Yes No