Answered

Using ODATA Filter Query

Like (1) Share

Report

Posted on 2 Aug 2024 15:00:13 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:

Business Process Flows

All responses (2)

Answers (0)

kddsling 49 on 05 Aug 2024 at 03:45:04

Like (0)

Report

Using ODATA Filter Query

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.
Suggested answer

David_MA 11,183 Super User 2025 Season 1 on 02 Aug 2024 at 18:02:08

Like (2)

Report

Using ODATA Filter Query

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.