Flow triggered every day but have to be delayed on weekends

[KarCz]

Hi PAutomate Users,

In my scenario:

I have a SP List, which are responsible for OnBoarding new employer. Each day it's triggered at 9am and is checking a column "Date of Arrival". If Date of Arrival is TODAY, user is receiving a "Hello" e-mail triggered by Flow.

What I want to achieve: If the date is on Saturday or on Sunday, it should be send in future, on Monday. So it should be delayed. How to achieve that?

Thanks for help!

BR,

Karol

[David_MA · Accepted solution]

You can use the DayofWeek expression to return the day of the week from your date of arrival date. This will return 0 for Sunday and 6 for Saturday. With a couple of conditions and delay actions, you should be able to achieve what you need.

The expression used in the conditions is:

dayOfWeek(utcNow())

You would replace utcNow() with your date field.