i'm building a flow where it will check a sharepoint list and get couple of data in order to schedule a meeting on outlook based on some criterias however i'm stuck on the following
Basically I have a date column and i need to calculate a start date-time & End date-time taking into account 2 working days (from Monday to Friday)
For example : if date = 29/03/2018
then start datetime = 02/04/2018 09:00
and end datetime = 02/04/2018 10:00
So that i can use both to schedule the event
Hi @ Friendyhere,
Could you please share more details about your needs?
Could you please share more details about your sharepoint list?
Does your sharepoint list have a date column?
Do you want to create a meeting on outlook when an item is created in the sharepoint list, and the meeting would be created after two working days of the value of the date column in the sharepoint list?
Please share more details so we could try to help you.
Thak you for your reply
basically I just need the correct exression for adding 2Business days+9hours to a given date record because it's required for "Create event V2" start time / end time
I tried to use the Addhours() function but i can't seem to figure out how to make it work so that it would take into account only business days
You can use the addHours function to get a date/time that is 2 days plus 9 hours from a given date.
To account for weekends, use the dayOfWeek() function in a switch statement. Use dayOfWeek to evaluate your addHours function. The dayOfWeek function will return 0 for Sunday and 6 for Saturday. In your switch statement, add additional hours as required in your dayOfWeek() calculation (24 or 48 hours additional).
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