Answered

Using ODATA Filter Query

(1) Share

Report

Posted on by kddsling

Hi All! So a recent project came up where I currently need to use ODATA filter. I have gotten as far as getting the real column name but now am trying to figure out what the ODATA filter query should be.

Currently I had created a string variable and have the value set as:

addDays(utcNow(),-30, 'MM/dd/yyyy')
 
My ODATA filter query is:
 
maintenance_x0020_ends eq 'MaintenanceTermination' but that appears to be an incorrect formula. Any assistance on this would be greatly apprecoiated!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David_MA 14,090 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

I am a bit confused as to why you are showing the expression for subtracting 30 days from the current date. How does that relate to your question and the query filter? If you are using the date in your filter query, dates need to be formatted as ISO8601 dates, which would be yyyy-MM-dd rather than MM/dd/yyyy.

If you pasted that by mistake and you are only asking about the query filter, when you use eq, it must be an exact match. I would add a Compose action to your flow and put the maintenance ends value into it. Run the flow so you can see what is returned so you can compare it to the filter.

Was this reply helpful? Yes No
kddsling 49 on at

Like (0)

Report
Copy link

Link copied!

David_MA is correct. I forgot to include the context for the formula. That was the formula I used as a value for a variable I created to use in the ODATA query. Both the suggestion on ISO8601 as well as the compose action were both what I needed.

Was this reply helpful? Yes No