Filtering "Get Items" by Modified month

[haniel]

Hello all,

I'm trying to create a flow that returns all items in a SharePoint list that were modified in the previous month.  Can someone help me with the proper syntax for the Filter Query?  Below is a screen shot of the Last Month variable calculation and the list I'm trying to query.

 

Thanks,

-Haniel

[JohnAageAnderse · Accepted solution]

Month(Modified) does not work in Flow. You have to use the functions available in Flow. This is what I came up with:

Observe that each expression above is surrounded by ' - single quotes!

where the first expression is defined as - start of last month:

startOfMonth(getPastTime(1,'MONTH'))

and the second expression is defined as - start of current month:

startOfMonth(utcNow())

This works for me 🙂 Hope this helps you on the way!

Kind regards, John

[Prav]

Hello,

Using the above expression but getting the error message below:

The expression "Modified ge '2019-07-01T00:00:00.0000000Z' and Modified It '2019-08-01T00:00:00.0000000Z'" is not valid.

[JohnAageAnderse]

Hello Prav

Please provide a screenshot of the actual flow step, where you have defined this Filter Query. Also provide the expression that you use. Thus we may be able to help you 🙂

Kind regards, John

[Prav]

Get Items from Sharepoint.

[JohnAageAnderse]

The screenshot looks ok, but what are the expressions that you are using?

Kind regards, John

[Kush]

Modified ge '@{startOfMonth(getPastTime(1,'Month'))}' and Modified It '@{startOfMonth(utcNow())}'

[JohnAageAnderse]

The issue is your 2nd part - the less than is not an L and T (lowercase) - please rewrite it 🙂

Kind regard, John