cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (58,265)