Unanswered

Filter Array is not working

(0) Share

Report

Posted on by SherryOu

Hi all,

I'm new to the power Automate and I think my need is quite easy but I don't know why the filter array is not working while the flow runs successfully, no error msg is popping up. Really need your helps!!!

I have a SharePoint list and I just want to receive those records which status is not equal to 'Closed' via email separately. But when I ran the flow, I got all the records, including Open and Closed.

When I ran the flow, here are the emails I received.

Categories:

Building flows

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SherryOu,

Can you try Status Value is not equal to Closed instead of the Status does not contain Closed in your Filter Array?

Also make sure you use the outputs of the Filter Array in your apply to each. Replace the value by the Body of the Filter Array.
SherryOu 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your suggestion. But it doesn't work either. I received all the records as well.
Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SherryOu,

Can you remove the single quotes around the word Closed?

Below is an example, if that helps.

In the example the below expression is used for the Subject field.

concat(item()['id'], ' ', item()?['Status/Value'])
SherryOu 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that works at the beginning, only showing the open ID!!
However, when I'm drafting my email content, like including the date, summary and the created by info, the Dynamic content only has the data from "Get Items" section. so once I choose these data, the flow shows all the records again.
Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SherryOu,

Yes, that's why I used expressions in my example. Because the fields are not listed in the Dynamic content list.

To make it a bit easier you can also use the Filter Query field instead of the Filter Array action. With that setup you should still see/pick the fields from the Dynamic content list 😀

The Filter Query field uses the below OData filter

Status ne 'Closed'