Power Platform Community Forum Thread Details

HI I'm new with PowerAutomate and I'm a little lost 😄

I need to make a flow that the first day of each month send me an email that report the number of elements (we use different Sharepoint list) of the past month that satisfy a specific condition (for a support tickets we have a field on that list with the close date, so we can filter that month dates in that purpose).

Well, I don't know is it's possible, if exist any template for do that or if anyone can give any idea for how can I make this, thanks in advance! 😉

Categories:

General topics

Hi @RBAR

I think this will do the trick. Since your Flow is triggering in the first day of the month we can do the following:

1. Take one day from the current date (get the last day of last month).

2. Find the start of the month

With this two elements we can define that the Created date should be from the first day of the month until the end of the month. This is your list of elements. You can parse them as you see fit and return the report.

It should look like this:

2021-05-24 12_35_49-Edit your flow _ Power Automate and 1 more page - Profile 1 - Microsoft Edge.png

Here's the formula:

Created gt '@{startOfMonth(addDays(utcNow(),-1))}' and Created lt '@{addDays(utcNow(),-1)}'

Can you please try and let me know if you have any questions?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.