Unanswered

Delay loop with Apply to each

(0) Share

Report

Posted on by Flo6

I am trying to create a flow that checks if the date someone put as returning is equal to today and then if so delay it by 1 day before sending an email. However since there are multiple responses there are occasions where two people return on the same day. The Apply to each function has interacted with the Delay funtion in an unexpected way and is looping the delay. It recognises that the date is the return date then delays by a day, sends one email. Then delays by a day again before sending the second email. How would I prevent the delay occuring twice as i want both emails to send after just one day of delay.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

wskinnermctc 6,519 Moderator on at

Like (0)

Report

Since this is a scheduled flow, is there a reason you could not just check if the Return Date was yesterday and send an email now? Seems like it would be the same except skip the need for a delay step.

Was this reply helpful? Yes No
Flo6 10 on at

Like (0)

Report

I wasnt sure of how to check for any day other than the uctNow. What would be the formula for yesterday?

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
You need to add a negative -1 day to today's date to get yesterday. If you use the addDays() expression you can add or subtract days from a date.
https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#addDays

addDays(utcNow(),-1)

Let me know if this works for you

Was this reply helpful? Yes No
Flo6 10 on at

Like (0)

Report

It worked as far as pulling through yesterday but wasnt recognising a match for the return date as it pulled through the time as well is there any way to not have the time?

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report
You'll need to formatDateTime(<timestamp>,'MM-dd-yyyy') for both of the values and then compare them.

Or you could do the format within the addDays() step.
addDays(utcNow(),-1,'MM-dd-yyyy')

Then you will be comparing "MM-dd-yyyy" to another "MM-dd-yyyy"

Was this reply helpful? Yes No
Flo6 10 on at

Like (1)

Report

Thats worked perfectly thank you so much for the help

Was this reply helpful? Yes No