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

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 Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,658)