Forum Discussion
SharePoint list with calculated column to work out SLA based on days and hours
Akshadaks SharePoint has no way of knowing what public holiday dates are, so you would need to build something different using a flow in Power Automate to do your calculations and lookup public holidays.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
I have user a workaround for that.
Created another column for adding the public holidays manually and that gets added to the SLA calculation.
There are still issues with it though. E.g. if the request is received outside business hours, the SLA should actually start from the next day's business hour and not based on the creation date/time.
I wonder if there is a way to keep another list with business hours and Power Automate to check if the request received is within that range, if yes, then blank, if no, then to consider the next business day and starting hour for calculation.