cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
haniel
Kudo Collector
Kudo Collector

Filtering "Get Items" by Modified month

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.

 

 DateQuery.png

 

 

Thanks,

-Haniel

1 ACCEPTED SOLUTION

Accepted Solutions
JohnAageAnderse
Memorable Member
Memorable Member

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

 

FlowModifedFilteredLastMonth.png

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

View solution in original post

7 REPLIES 7
JohnAageAnderse
Memorable Member
Memorable Member

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

 

FlowModifedFilteredLastMonth.png

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

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.

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

error.png

 

Get Items from Sharepoint.

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

Kind regards, John

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

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

Kind regard, John

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.

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 (2,931)