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.

All responses (2)

Answers (0)

shalini 18 on at

Like (0)

Report

Re: can you let me know how filter array works in Flow

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.
v-yamao-msft on at

Like (0)

Report

Re: can you let me know how filter array works in Flow

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