Hello,
I want create a scheduled flow to run every day, Monday - Friday, excluding holidays and weekends to take a specific tab of an Excel workbook saved on SharePoint to an Excel workbook that resides on the network drive. The Excel workbook on the network drive will take a specific tab from the SharePoint Excel workbook and name it the same but add the current date to the end of it.
For example, the specific tab from the SharePoint Excel workbook called "Deliveries", each day the flow should copy the "Deliveries" tab and put it into a workbook called "Orders" on the network folder. The tab name for today should be named "Deliveries 3-28-24", the tab name for tomorrow (Friday) will be "Deliveries 3-29-24", the third tab name should be "Deliveries 4-1-24" since 3-30-24 and 3-31-24 falls on a weekend. If holidays cannot be dynamically determined then that's fine, but excluding weekends is important.
Is this something do-able? Any help is appreciated, preferably with a picture or video.
TIA!
