Mothly Flow and Testing

[Andrew_J]

Hi All,

I have the following list which is a month and item description.

The idea is to send out an email based on the next months tasks.

However I need to test the flow.  I want to filter by say APR or AUG, I know I need a compose as test for the filter; but what would the expression be that I could use as part of the testing. 

Once the flow is working then I will use the recurrence at the start and send the next months tasks on the 10th of the month for next month.  So some help on this would be good.

I then plan to send out to all in SP Group which I know how to do.

Any help would be appreciated.

Regards

Andrew

[SudeepGhatakNZ]

You can simply use the Get Items action to achieve this.

Use the UtcNow() function to get the current month.

Use an oData filter based on this month.

Get items will return you an array of items that match the filter criteria.

[Andrew_J]

@SudeepGhatakNZ 

Many thanks that worked and I now have the following as the start of the flow:

And get the output I need for the rest of the flow

One final question how do I get it to send Decembers tasks at say the middle of November.  I think i need to adjust the month variable to addDays() in the somewhere.

Regards,

Andrew 

[Ajinder31]

Hi @Andrew_J , You're correct about adding days to month variable. I think you can modify the intialize variable - Month action to intialize it as next month. For example 

formatDateTime(addDays(utcNow(), 21), 'MM')

[SudeepGhatakNZ · Accepted solution]

@Andrew_J ,

I guess in that case, you can schedule your flow to run on 15th of each month.

Using addDays function, you can add 17 days to your variable (to account for 31 day months) to calculate the next month 

formatDateTime(addDays(utcNow(), 17), 'MM') will give you 12

formatDateTime(addDays(utcNow(), 21), 'MMM') will give you DEC