Unanswered

Increment date in email

(0) Share

Report

Posted on by Queenslander

I want to send a weekly email (I've set up the occurrence fine) that has a date range in the body of the email that increments by one week each time (falling on the Tuesday). For example:

On Thursday 19th May, an email will be sent with text in it that says " 01 July 2021 to 17 May 2022".

On Thursday 26th May, an email will be sent with text in it that says "01 July 2021 to 24 May 2022".

Etc.

My flow is pretty basic - it just has two steps - the recurrence then the sending of the email. How do I set up that date incrementing in the body of the email?

Thanks everyone.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @Queenslander ,

Please try:

Expressions:

startOfMonth(addDays(utcNow(),-2),'dd MMMM yyyy')

addDays(utcNow(),-2,'dd MMMM yyyy')

Result:

Best Regards,
Bof

Was this reply helpful? Yes No
Queenslander on at

Like (0)

Report

Hey Bof!

Yes, that worked! I just tweaked addDays(utcNow(),-2,'dd MMMM yyyy') to be -1 instead of -2 as I guess it doesn't count today's date.

Thanks so much 🙂
Queenslander

Was this reply helpful? Yes No