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

[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)

[creativeopinion · Accepted solution]

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

[Charlie1586]

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.

[creativeopinion]

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.