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
Solved! Go to 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:
and the second expression is defined as - start of current month:
This works for me 🙂 Hope this helps you on the way!
Kind regards, John
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:
and the second expression is defined as - start of current month:
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
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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
19 | |
15 | |
11 | |
10 | |
9 |