Answered

Unable to filter array an excel body/value with multiple condition

(0) Share

Report

Posted on by Denisss Microsoft Employee

Hi, I'm currently creating a flow where I try to filter Excel using the filter array. I have successfully run the flow by separating the two filters into one filter for 'less than' and another for 'greater than'. After that, I use the intersection compose. However, I wonder if it is possible to create it into one filter array with multiple conditions. I tried using the formulas below but failed. I hope someone can help. Thanks.

@and(
less(@{item()?['_Start_Date']},@{body('Time_tomorrow')}),
greater(@{item()?['_End_Date']},@{formatDateTime(body('Time_today'),'yyyy-MM-ddTHH:mm:ss.0000000')})
)

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Where does "body" come from? Is that a separate record holding the comparison dates?

Here's what works for me:

{ "type": "Query", "inputs": { "from": "@outputs('List_rows_present_in_a_table')?['body/value']", "where": "@and(less(item()?['Sent'],'2023-10-31T00:00:00.000'),greater(item()?['Sent'],'2023-09-30T00:00:00.000'))" }, "runAfter": { "List_rows_present_in_a_table": [ "Succeeded" ] } }

Use expressions in conditions in Power Automate - Power Automate | Microsoft Learn

Have you considered including the (OData) filter in the Excel call directly?
Verified answer

Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Try removing all the extra at signs and curly braces. Those should only be in the outermost comparison. Use this formula instead.

@and( less(item()?['_Start_Date'],body('Time_tomorrow')), greater(item()?['_End_Date'],formatDateTime(body('Time_today'),'yyyy-MM-ddTHH:mm:ss.0000000')) )

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog
Denisss Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thankyou Paul. The flow runs as intended.