AnsweredAssumed Answered

For Each Loop Evaluate Day of the Week Issue

Question asked by rwrzesien on Mar 15, 2017
Latest reply on Mar 16, 2017 by emha

My process consists of once a new item has been created in a list, the list should call back to previous items and update a date field based on business and holidays. The only field I need to change is the date. The remaining can be copied.


The reason for this automation is we have a SP calendar that contains all the same data except the date for each quarter. My goal is create a workflow that populates all data once an item is created. The changing factor is the date based on business days and holidays. I need to skip over Sat and Sun.


I have managed to create this successfully using the Loop action. The problem I have is the time it takes to create each items, 5 mins, up to 30 total. My next approach was a For Each, the issue I have is leveraging a field that changes and can manipulate a variable to change the date. Basically stuck on evaluating the day of the week. Does anyone recommend a different approach or do you think the issue is with a unique identifier to instruct the work flow to evaluate the date?