Answered

Daily Recurring e-mail how to automatically populate date and day of week in subject line?

(0) Share

Report

Posted on by ehenry223

I have a flow set up to send a recurring email to a group of people at the same time every day. Is there a way to have the flow automatically insert the current day of the week and the date in the subject line? I want to be able to discern between one email thread sent from one day and other thread without having the exact same subject line. I used IFTTT previously which had an ingredient to add this feature but IFTTT is no longer working with Gmail. Any help is much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@ehenry223

You can use the utcNow() expression along with the formatDateTime() expression to get the current date formatted any way you want it - see me example below.

You can use the dayOfWeek() expression along with utcNow() to get the current day of the week. The expression returns 0 for Sunday, 1 for Monday, etc.. You'll need to convert the numbers to days using a switch statement, condition or a lookup.

My expression can be seen in the comments area.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (2)

Report
Hi @ehenry223 ,

@ScottShearer is correct. and what would you like the subject like?

You could refer to screenshot below to combine the day of week and the date in the subject will type: day of week - date

concat(dayOfWeek(utcNow()),' - ',formatDateTime(utcNow(),'yyyy-MM-dd'))

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ehenry223 8 on at

Like (1)

Report

Thank you! I got this to run successfully by removing an extra parentheses "concat(dayOfWeek(utcNow()),' - ',formatDateTime(utcNow(),'yyyy-MM-dd')"

Do you know how I would convert the day number of the week to the actual name (i.e. Mon, Tues, Wed, etc.)?

Was this reply helpful? Yes No