Dynamic date (previous month) in email subject and body

[Mirela_Raducanu]

Hi, i am creating creating a flow to send a monthly report. My report is supposed to be sent on the first day of the month. Is it possible to have a dynamic date in my email subject and body? 

The August report will be sent out on 1st of September and my email subject should be Monthly Report 08/2023.

Email body will be "Dear xx, please find attached the Monthly Report for August 2023"

Appreciate the help. 

[Nived_Nambiar · Accepted solution]

Hi @Mirela_Raducanu 

Assuming the bot sends out mail every first day of month, use send email action with below expression in subject and email body for dates 

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Mirela_Raducanu]

@Nived_Nambiar Thanks. It partially works, in the sense that the syntax retrieves the current month. Any idea how to fix this? Much appreciated. 

[Nived_Nambiar · Accepted solution]

Hi @Mirela_Raducanu 

Its because you have ran it today and my current expression subtracts one day from it. The reason behind trying this expression was because since the flow runs first day of every month, let's say on 1st sep 2023, it will subtract one day from it which then date becomes 31st August 2023 from which month and year format are obtained 

So from that perspective it would work.

But you can try this way as well if you want 🙂

This will compute start date of any date of the month and the  subtracts 1 day from it to get in previous month 

Expression:  addDays(startOfMonth(utcNow()),-1,'MM/yyyy')

Output got 

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Mirela_Raducanu]

@Nived_Nambiar it works perfectly. Thank you.