web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get Items - Within two...

Power Automate

Answered

Get Items - Within two dates listed

(0) Share

Report

Report

Posted on by jrod86

19

Hello! I'm trying to filter query for SharePoint items between two dates listed in this format: yyyy-mm-dd in a SharePoint list (post date, and expiration date of post).

I'm looking to filter to all the items that would fall between those two dates.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
Hi!

Assuming you added two "Initialize variable" action blocks, both type string, names PostDate and ExpirationDateOfPost, values the dates you wanna take as the limits, both of them in the format yyyy-MM-dd.

Now on your 'Get items' action block you can define an ODATA filter on 'Filter query' input (you need to click 'Show advanced options' to see this input) by typing the following:

InternalColumnName gt '@{variables('PostDate')}' and InternalColumnName lt '@{variables('ExpirationDateOfPost')}'

Just replace 'InternalColumnName' with the one corresponding to your target column in your Sharepoint List

GReat article on ODATA filters for Sharepoint here

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

Not in my laptop, unable to help

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
Hi again!

Back to my laptop, I just did a simple test with standard column Created and works like a charm

So in the example my ODATA Filter provides items created either on 2020-09-14, 2020-09-15, 2020-09-16 or 2020-09-17. Please note Sharepoint standard Created column stores date+time in ISO 8601 format:

yyyy-MM-ddTHH:mm:ssZ

Hope this helps

Was this reply helpful? Yes No

Join the conversation