Hi All,
Anyone can help me on below?
I want to set a condition where
if DateTimeReceived is equal to 6 (or Saturday)
Forward email to specified email address.
How should i set the if DateTimeReceived is equal to 6 (or Saturday)?
i try with
Compose
DayOfWeek(triggerbody()?['DateTimeReceived'])
but return this is not valid expression.
Solved! Go to Solution.
Many thanks for your help on this, it is much appreciated. I am not clear as to what the Compose formula should be. Below is the original formula, that returned (3):
dayOfWeek(formatDateTime(triggerbody() ['cr0ad_referraldate'],'D'))
The following if the revised Compose formula (I have changed the Referral Date to Friday's date in the Case):
dayOfWeek(formatDateTime(triggerbody() ['cr0ad_referraldate'],'dddd'))
This formula is returning an error message:
Have I got the Compose expression wrong?
Also, what should the condition expression be, once the Compose function returns the alphabetic value for day of the week?
Chris
If you want the name of the day as output then you don't need the DayOfTheWeek() function around the outside anymore. DayOfTheWeek() returns the number of the day, but you want the name.
Many thanks on this. I have it working correctly now.
Have a good weekend.
Chris
User | Count |
---|---|
94 | |
39 | |
24 | |
21 | |
16 |
User | Count |
---|---|
128 | |
49 | |
48 | |
31 | |
24 |