cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chriss1982
Helper I
Helper I

Odata Filter for specific date

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. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Chriss1982 

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

Your filter should look something like this:

SameDate.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

3 REPLIES 3
ScottShearer
Super User
Super User

@Chriss1982 

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

Your filter should look something like this:

SameDate.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
ChristianAbata
Community Champion
Community Champion

hi @Chriss1982  you can follow this example

 

date.PNG

 

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
yashag2255
Dual Super User II
Dual Super User II

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!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,014)