I need some help on this point, I have a flow in which it receives a date and a day as a result show the date plus the amount of days but now I need to exclude weekends from the result
This is my formula that works perfectly, however, this includes weekends and I would like to take weekends out
You'll want to use the dayOfWeek() expression and apply it to the date that you have calculated. dayOfWeek returns 0 for Sunday and 6 for Saturday. So, you might, for example, add one more day if the result is 0 and two days if the result is 6.
You could do all of this in a single expression, but it would be really ugly - I would divide it into two or three expressions probably inside of Compose actions.
Let me know if you need more help.
Please see my screen shot below. A Switch action is appropriate here.
Where are you using the Dayofweek functionality in the screenshots you mentioned. Also where you are getting the error what variable are you using to get the output in switch.
My suggestion is as follows
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!