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
Super User
Super User

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
Super User
Super User

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

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 User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (49,194)