Answered

Use ODATA Filter in 'List rows present in table' to find rows between two dates

(0) Share

Report

Posted on by Charlie1586

I have a table in an excel doc that is like a diary. It has a column called 'Date'. The rest of the diary columns contain the event that is on that day and a column for each member of our freelance staff, where I put whether or not they are available for that event.

I want to create a flow that will ask me to input and start and end date and will then filter the rows in between those dates.

After this I would want it to find the people who I have not inputted 'Yes' or 'No' for, and email those people to ask if they are available however, I cannot get passed the filter part.

I cannot get my head around ODATA filter and, when I try a Filter Array, I can only filter by one parameter (ie. either greaterthanorequal or lessthanorequal)

Categories:

Building flows

Capture.PNG

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
You need to use the Advanced Mode in the Filter Array action. FYI: The Advanced Mode is not very advanced. You need to actually compose your expression in a text editor. It's horrendous to edit in.

What I would suggest you do is compose the condition in basic mode first. Like so:

The press Edit in advanced mode and copy/paste the expression to your text editor.

Do the same for the other conditions. Your expression would look something like this:

@And ( greaterOrEquals(item()?['AssignedOn'], triggerBody()['date']), lessOrEquals(item()?['AssignedOn'], triggerBody()['date_1']) )

Note: The last condition does not have a comma and the @ symbol should only appear prior to the 'and'. Also, my column name I was selecting from is AssignedOn, your expression will look different based on your column name.

Build your expression in a text editor and copy/paste it into the filter array action.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No
Charlie1586 10 on at

Like (0)

Report

It says the following:

The power flow's logic app flow template was invalid. The template language expression 'and( @greaterOrEquals(item()?['Date'], triggerBody()['date']), @lessOrEquals(item()?['Date'], triggerBody()['date_1']) ) ' is not valid: the string character '@' at position '5' is not expected.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Sorry I made an error with the expression, the @ symbol should only be in front of the 'and' and there shouldn't be an @ symbol in front of the greaterorequals and the lessorequals conditions.

I've edited my original response.

Was this reply helpful? Yes No