Calculate Working Day

In Power Automate

Showcase how we can calculate working day

Pre-requisites

What are we going to use

Calculate Working Day

• Link 1 - Website
• Link 2 - Blog Post
• Link 3 - Microsoft Learn

Problem 1

We have a shared mailbox

and we want to make sure we deal with emails within 10 working days

our working days are Monday to Thursday excluding bank holidays in Scotland

The Solution

Parameters

Returns

{
  "flag": {
    "flagStatus": "flagged",
    "startDateTime": {
      "dateTime": "YYYY-MM-DD",
      "timeZone": "UTC"
    },
    "dueDateTime": {
      "dateTime": "YYYY-MM-DD",
      "timeZone": "UTC"
    }
  }
},

Link 4: followupFlag resource type - Microsoft Graph v1.0 | Microsoft Learn

PATCH https://graph.microsoft.com/v1.0/users/{mailbox}/messages/{id}

PATCH https://graph.microsoft.com/v1.0/users/demo@tweed.technology/messages/{id}

Link 5: Update message - Microsoft Graph v1.0 | Microsoft Learn

Test

Oh no!!!!

Problem 2

We run an office equipment rentals business

We bill based on the number of working days

The Solution

Parameters

Returns

What We’ve Accomplished

We have using low code being able to Calculate Working Days

• ✅ Date Difference
• ✅ Date In X Working Days

Where can you get this

• Link 1 - Website

Feedback

https://go.iantweedie.biz/feedback