Unanswered

Power Automate - Filter Array is Not Giving a Result

(0) Share

Report

Posted on by ffscastillo

Hi!

Guys, need some help on my flow on the Filter Array aspect on which the body of the Filter is not providing a result. In the below screenshot, I am trying to get the "ID" information from the SharePoint list based on the lookup type column named "Legacy ID" entered in an Excel table. But in the output body it is being blank although I am sure that the Legacy ID is available in the excel file.

Thanks in advance for the help.

This is what I defined.

And this is the result when I run it.

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (1)

Report

Hi @ffscastillo ,

Check that you are using the correct column names for SharePoint and Excel in the filter array action.

One trick you can use to check if ['Relating to EE ID'] property name is valid is to remove the ? from the expression and re-run the flow to see if the flow continues or stops with an error:

See: How to Query JSON Data Using JSON Notation with Power Automate❔❔❓| Sometimes you NEED your flow to stop with an Error!

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
ffscastillo 10 on at

Like (0)

Report

Hi Ellis,

This is a good advice. I will try this out and see if I can identify the issue doing this. Thank you!

Francis

Was this reply helpful? Yes No
ffscastillo 10 on at

Like (0)

Report

Hi @ekarim2020,

I tried to remove the question mark and the flow went successfully unfortunately still with the same result of nothing in the body of the output.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Could you provide your real JSON array you wish to filter?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report
Hi @ffscastillo

I think may be the datatype issue

give a try with this

@equals(item()?['LegacyID'],int(items('Apply_to_each_row')?['Relating to EE ID']))

Let me know if it worked 🙂

Was this reply helpful? Yes No
ffscastillo 10 on at

Like (0)

Report

Hi @VictorIvanidze ,

The screenshot I provided in the "From" section of the Filter is actually the data that I am trying to get the "ID" on which I am trying to get the "Legacy ID" which is a Lookup Column in my source list and the column and it's source is having an Number type of column.

Was this reply helpful? Yes No
ffscastillo 10 on at

Like (0)

Report

Hi @Nived_Nambiar ,

This idea is good to work since the source data of the Lookup column that I am getting is a Number type column. However after doing your suggestion the body is still giving no result.

Applied the suggestion.

This is the result.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ffscastillo

Do one thing, could you show the json structure where the values legacy ID and Relating to EE ID looks like ?

Just to see whether we need to use any other operations to make it equivalent ?

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ffscastillo ,

Please remove the space character from the filter array condition and re-run the flow:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No