ODATA Filter 'ge' 'gt' etc. not working for me

(0) Share

Report

Posted on by Community Power Pla...

Hi there im trying to use ODATA filter to filter out dates that are exactly 31 days old or older.

I've been testing out using "ge" and "gt" filters but this is the error i get every time.

"eq" filter works, but i'd like to also keep notifying when its greater than the date not just equal to it.

Any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (3)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous as the error says, ge and gt filters are not supported. You can use Filter Array action to further filter rows returned from excel to filter by date.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I realized as i posted this it should of course be "lt" or "le" but that does not work either since the site says it's not supported.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Anna,
Thanks for the input.
As i'm new to this, could you give me an example of a filter array that would provide this?
If you have the time.

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous you can refer to this blog post https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/

Was this reply helpful? Yes No
Verified answer

RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

Not wishing to step on @annajhaveri 's toes but I had an example already open as I was explaining filter arrays to a colleague:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank aslot, Rob and Anna.

@RobElliott
So for instance, would this filter give me the dates that are inserted into the column "SeinastUppfært" that are older than 31 days?

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

Like (0)

Report

I would do it with formatDateTime(addDays(utcNow(),-31),'yyyy-MM-dd')

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Hey again, thanks for the feedback @RobElliott I combined the suggestion but could not get it to work for some reason, however I tried a workaround that was found within the link that @annajhaveri provided that worked for me. I created another column in my spreadsheet that gives a True or a false if the date from the date column was more than 62 days old (Changed conditions to 2 months). then I used the ODATA Filter to filter by that column to send the emails if it that column equaled to "True"
It's a very straight forward brute force workaround but if anyone's having this issue this is what I did:

Thanks again for your inputs.

Was this reply helpful? Yes No