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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
33 | |
16 | |
15 | |
12 | |
9 |
User | Count |
---|---|
39 | |
21 | |
19 | |
10 | |
9 |