web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Calculate SLA 8 hours ...
Power Automate
Unanswered

Calculate SLA 8 hours exclude weekends, Holidays and the request must be opened only in business hours from 09:00am to 17:00pm.

(0) ShareShare
ReportReport
Posted on by 28

Dear Expects,
I would like to create a flow to restrict request creation to business hours while considering holidays and weekends:

  1. Trigger: Start the flow when someone tries to create a request.

  2. Check Business Hours: Use a condition to check if the current time is within business hours (e.g., from 9 AM to 5 PM). If it's outside of business hours, send a notification informing that requests can only be made during business hours.

  3. Check Holidays and Weekends: If the time is within business hours, check if the current date is a holiday or weekend.

    • Consult your list of holidays to determine if the current date is a holiday.
    • Use a function to check if the current date is a Saturday or Sunday.
  4. Create Request (If All Conditions Are Met): If the time is within business hours and it's not a holiday or weekend, proceed with creating the request.

  5. Send Rejection Notification (If Any Condition Fails): If the time is outside business hours or it's a holiday/weekend, send a notification stating that the request cannot be created due to restrictions.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 305 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 155 Most Valuable Professional

Last 30 days Overall leaderboard