You’re offline. This is a read only version of the page.
Announcements
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! 😉
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:
Here's the formula:
Share
Report
All responses (
Answers (
6,625
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.
