cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarCz
Helper I
Helper I

Flow triggered every day but have to be delayed on weekends

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

1 ACCEPTED SOLUTION

Accepted Solutions
David_MA
Impactful Individual
Impactful Individual

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.

David_MA_1-1669744553833.png

 

The expression used in the conditions is:

 

 

dayOfWeek(utcNow())

 

 

You would replace utcNow() with your date field.

View solution in original post

1 REPLY 1
David_MA
Impactful Individual
Impactful Individual

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.

David_MA_1-1669744553833.png

 

The expression used in the conditions is:

 

 

dayOfWeek(utcNow())

 

 

You would replace utcNow() with your date field.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,453)