Odata Filter for specific date

[Chriss1982]

Hi all, 

I want to select all items in a list with a specific date. 

For example:

My Power Automate is running, when a new item in a SP list is created. One filed of this list is "Expiration Date". 

So when a new item is ceated with Expiration Date: 12.12.2020 I want to select all other items with the same "Expiration Date". I suppose this would work with "Get Items" and the ODATA filter but I don´t know how. 

[ScottShearer · Accepted solution]

@Chriss1982 

You can, as you suggested, use a Get Items action with an OData filter.

Your filter should look something like this:

[ChristianAbata]

hi @Chriss1982  you can follow this example

Date is my column list, and I compare with my exp date

[yashag2255]

Hi @Chriss1982 

The date format that you need to have the date in the query is yyyy-MM-dd. You can refer to the other responses to construct the query accordingly. Note that this would work on columns of type date only. If it has time also, the format needs to be yyyy-MM-ddThh:mm:ss. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!