dayOfWeek not working

(0) Share

Report

Posted on by Belasor

139

Hi all,

I build a Flow where I check if the current day is a weekday. I do this with following code

dayOfWeek(body('Add_to_time_CurrentDay'))

However the value which I compose with dayOfWeek is returning me the number. I´m passing the value to a condition and check if the value is not equal to 6=Saturday or 0=Sunday.

Unfortunately every value is true, so the final result also include the weekend days. 2020_07_24_11_21_39_adminrds_Remote_Desktop_Connection.png

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

please @Belasor try adding and expresion string with the numbers, instead the numbers in your condition. see

Was this reply helpful? Yes No
Belasor 139 on at

Like (0)

Report

Unfortunately this is also not working with the same result.

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Hi @Belasor,

The issue is caused by the logic in Condition action not correct.

No matter which day of the week, it will return to the true.

If the day of the week is 1-5, it will meet two conditions and return true;

If the day of the week is 0, it will meet the second condition and return true;

If the day of the week is 6, it will meet the first condition and return true.

So if you want to determine the day of the week whether is weekend, please change the condition to And:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Belasor 139 on at

Like (0)

Report

Thank you for the answer. Unfortunately also this is not working

Was this reply helpful? Yes No
v-litu-msft on at

Like (1)

Report

Hi @Belasor,

Please not use the string() function convert integer 6 and 0 to string "6" and "0", cause the return of dayOfWeek() function is an integer, different types couldn't compare:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No