Unanswered

Filtering Sharepoint List - Strange behavior

(0) Share

Report

Posted on by MM

I created a Flow that sends an email based on the filtered content of a list.

I created a FILTER ARRAY that gives me a BODY as output. Although, seems like I cannot use the BODY details as parameters for the mail content in the APPLY TO EACH I use after filtering. BUT, if I first use VALUE, fill the content and body of email, then remove VALUE and put BODY, save and close... then all the references are made correctly to BODY.

Is it me?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xida-msft on at

Like (0)

Report
Re: Filtering Sharepoint List - Strange behavior

Hi @MM,

The strange behavior is confirmed on my side. The outputs of “Get items” action and “Filter array” action are both Array. Once you changed the Value content(“Get items” action returns) to Body content(“Filter array” action returns) in “Apply to each” box and saved the flow, all the references would make corresponding changes based on input parameter of “Apply to each” automatically.

Besides, although we cannot use dynamic content of “Filter array” action as parameters for content of “Send an email” action, we can take a try with the following workaround to achieve Body's details:
Select “To” property of “Send an email” action and click “Add dynamic content”
Select “Expression” tab, in expression box, type the formula as below:
item()?[‘EmailColumn’]
Other properties use the similar formula.
The flow works successfully as below:

Best regards,
Kris

Was this reply helpful? Yes No
MM 39 on at

Like (0)

Report

Re: Filtering Sharepoint List - Strange behavior

Thanks I thoight it was a bug, maybe it’s a feature:-)

And yes, confirming that after saving, it works perfectly!

Was this reply helpful? Yes No