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
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.