can you let me know how filter array works in Flow

(0) Share

Report

Posted on by shalini

I have a reuirement where i want to fetch some data based on some condition from sharepoint list.

i was using condition in apply to each item in sharepoint list and thats works well.

i came across Get item where we have odata query wjere we could apply query based on some condition.But it unsuccessful when i am applying some condition using filter array.

could you let me know the correct way to use it. the output is always 0.even though the condition matches.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @shalini,

From the screenshot, you are adding the action Filter array under Apply to each. Please try to add the action under the Get items directly.

Please take this doc on Filter array action for more details:

https://docs.microsoft.com/en-us/flow/data-operations

I also made a test on my side and it returns values as expected.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
shalini 18 on at

Like (0)

Report
Copy link

Link copied!

How can we use more than one statement in filter query with get item.

We can do columnname eq 'value' but what if i have to use and with two statement.

Was this reply helpful? Yes No