Answered

formula to delay email until next day?

(0) Share

Report

Posted on by powersusers

formatDateTime(addDays(body('Get_response_details')?['submitDate'],sub(5,dayOfWeek(body('Get_response_details')?['submitDate']))),'yyyy-MM-dd')

Im currently using this formula which makes a flow trigger sending an email on a friday, but i want to slightly change it so that it will instead cause the email to be sent the next day

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

powersusers 53 on at

Like (0)

Report
Copy link

Link copied!

one more question: when trying to save the flow it gives error

"Correct to include a valid reference to 'Get_response_details' for the input parameter(s) of action 'Delay_until'."

https://i.imgur.com/DXOmKBC.png

would anyone know what causes this issue?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Hello @powersusers
If you are referring about adding 1 day to today then could you try arranging your expression similar to the below.

addDays(utcNow(),1,'yyyy-MM-dd')

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Regarding your second post, the image does not open up. Says "The webpage at https://i.imgur.com/DXOmKBC.png might be temporarily down"

Looks like something is not given like the way it should be. Can you take some hints on the error from this post below
https://powerusers.microsoft.com/t5/General-Power-Automate/Get-Form-response-details-as-JSON-error-message/td-p/578811

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @powersusers
If you want to send an email notification the next day, please use the method provided by @VJR .
Because timestamp needs to be filled in do until action, so please format the time as 'yyyy-MM-ddTHH:mmZ'.
'HH' refers to hour, 'mm' refers to minute.
Do until at 10 o'clock the next day.
If you want to send an email notification delay one day, you can use delay action directly.
Regarding your second question, because the trigger you used is when a new tweet is posted, Get response details is used together with When a new response is submitted trigger. So it will have an error.
Hope the content above may help you.
Best Regards

Was this reply helpful? Yes No
natng 5 on at

Like (0)

Report
Copy link

Link copied!
I've tried your method to delay until 09:30AM on a particular day. But its not working, is this a time zone issue? Previously without fixing it to a specific time of the day, my addday formula works fine. Please help.

addDays(triggerOutputs()?['body/CollectionDateTime'],-2, 'yyyy-MM-ddT09:30:00Z')

Was this reply helpful? Yes No