Send reminders on certain days after checking item count of current month

(0) Share

Report

Posted on by amk1421

195

I need to run the flow on each months 10th and 12th then 26th and 27th

for 10th and 12th of month check if item count (from last month) is less than "2" then send reminder
for 26th and 27th of month check if item count is less than "1" then send reminder

I get current month item count by

Get items:

Created ge 'startOfMonth(getPastTime(0,'MONTH'))'

Get item count:

length(body('Get_items')?['value'])

How do I implement other requirements. How do i get

-Previous month item count. Would I add another "Get items" action and with what filter?

And how to test the flow

-For example: Compare with a date column For_the_month in "Get items" Filter so instead of

Created ge 'startOfMonth(getPastTime(0,'MONTH'))' it will be Created eq 'For_the_month', but that is not possible as Get items return collection with all the For_the_month values

Please guide with the above
@grantjenkins @VJR @Expiscornovus @Sundeep_Malik @annajhaveri @abm @SudeepGhatakNZ @Rhiassuring @tom_riha

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @akg1421 ,

From your description, your flow seems to be working fine, but I can't figure out what the problem you are actually facing. Could you please show me more details?

How do I implement other requirements. How do i get

-Previous month item count. Would I add another "Get items" action and with what filter?

Yes, you can also get all the items first, and then use two filter array actions to get the items you want.

And how to test the flow

-For example: Compare with a date column For_the_month in "Get items" Filter so instead of

Created ge 'startOfMonth(getPastTime(0,'MONTH'))' it will be Created eq 'For_the_month', but that is not possible as Get items return collection with all the For_the_month values

I don't understand the meaning of this passage. Do you want to filter on For_the_month column instead of Created?What are the specific filter conditions? What is For_the_month? Is it a numeric column showing the month or a date column? Could you please show me more details?

Best Regards,

Bof

Was this reply helpful? Yes No
amk1421 195 on at

Like (0)

Report
Copy link

Link copied!
@v-bofeng-msft

How do I implement other requirements. How do i get
-Previous month item count. Would I add another "Get items" action and with what filter?

Yes, you can also get all the items first, and then use two filter array actions to get the items you want.
What Filter query should I use to Get items from previous month? Is the following correct?
Created ge 'startOfMonth(getPastTime(-1,'MONTH'))'

And how to test the flow
-For example: Compare with a date column For_the_month in "Get items" Filter so instead of
Created ge 'startOfMonth(getPastTime(0,'MONTH'))' it will be Created eq 'For_the_month', but that is not possible as Get items return collection with all the For_the_month values

I don't understand the meaning of this passage. Do you want to filter on For_the_month column instead of Created?What are the specific filter conditions? What is For_the_month? Is it a numeric column showing the month or a date column?

Means when I need to test the flow I can't be waiting for 10th and 12th of the month to see if the notification is received at user's end. If i manually run the flow for "testing purposes", I for instance, can compare to a date range or a date column "For_the_month" (SP list column). Is the following correct Filter query ok?
Created eq 'For_the_month'

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @akg1421 ,

Please try:

Created ge 'startOfMonth(getPastTime(1,'MONTH'))' and Created lt 'startOfMonth(getPastTime(0,'MONTH'))'

No, it is not available.

Best Regards,

Bof

Was this reply helpful? Yes No