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
Solved! Go to 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.
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.
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
50 | |
48 | |
35 | |
26 |