PowerPlatformConnectors/certified-connectors/Calculate Working Day

Calculate working day

The Calculate Working Day is a tool for developers to easily compute a valid working day, accommodating a range of requirements from basic to complex scenarios. It seamlessly integrates with user-defined working days and UK bank holidays and can perform a number of functions. With a more advanced setup, developers can tailor the computation to adhere to specific working day patterns. By supplying a customized list of working days—designated by their corresponding day-of-week codes—the connector can precisely determine the subsequent working day, considering the user-defined schedule.

Publisher: Mightora.io

At Mightora.io, we are dedicated to transforming your development process by offering exceptional Power Automate connectors and APIs. Our goal is to not only reduce your development costs but also empower your developers to embrace citizen development. With our innovative solutions, you can expect a seamless and efficient development experience that will drive your success forward. More information can be found on our website

Prerequisites

To use this connector you will need the following to proceed:

• A Microsoft Power Apps or Power Automate plan
• An API key from our website choosing billing from either RapidAPI or Blobr

Supported Operations

Combined

Performs a combination of all of the endpoints in one response.

Basic Next Working Day

Finds the next working day based on a working week of Monday to Friday.

Next Working Day

This action uses multiple variables to determine what your working days are in order to return the correct Next Working Day after the date you provide.

First and Last Working Day of Month

This action uses multiple variables to determine what your First and Last working days of a given month are.

Is Today A Working Day

This action uses multiple variables to determine if today/date supplied is a working day for you.

Date In X Working Days

This action uses multiple variables to determine what the working day will be in X working days’ time.

Obtaining Credentials

Credentials can be obtained from one of our two billing partners, either from RapidAPI or Blobr. The full process is outlined below. For support please head on over to our website here.

How to get credentials from Rapid API

1. Go to RapidAPI
2. Sign up for an account
3. Click on Subscribe to Test
4. Choose your plan, the Basic plan is free
5. Subscribe to the plan
6. Then click on Endpoints and copy the value from X-RapidAPI-Key
7. Paste the value into the API Key field
8. Choose RapidAPI as your Endpoint

How to get credentials from Blobr

1. Go to Blobr
2. Sign up for an account
3. Click on Try for free
4. Enter in your details, the trial is free
5. Subscribe to the plan
6. Then click on Authentication and copy the value from Primary API Key
7. Paste the value into the API Key field
8. Choose Blobr as your Endpoint

Getting Started

You can use this connector in the following cases:

1. Obtain a api key either from RapidAPI or Blobr.
2. Add the step in to your Power Automate Flow
3. Enter in your api key and select your endpoint
4. Pass in the value of your domain, you can also pass in a full email address however we only need the domain

Known Issues and Limitations

• Currently there are no knonw issues
• Currently we limit to 1000 calls per minute per apu key, we will look to increase this if there is demand

Using the connector

To use our connector;

1. Add it in to your Power Automate Flow.
2. Create your connection by entering your Mightora IO API key from RapidAPI or Blobr
3. Choose your action
4. Pass in the optional and required parameters depending on the action.

Parameters that can be used

• date - The date in question you wish to centre your request around. This is the input date in YYYY-MM-DD format. e.g. 2022-12-23.
• working_days - This parameter expects a comma-separated list of working days, where Monday is 1, Tuesday is 2, and so on. In the default, we're using all weekdays from Monday to Friday, so the value is '1,2,3,4,5'.
• x_working_days - Find working day in X days e.g. 4
• country - Currently, only the United Kingdom is supported. Values can be england-and-wales, scotland, northern-ireland. Used to filter out bank holidays.
• non_working_days - A custom list of non working days, this could be a list of days where service is not available. In a string as a list, format YYYY-MM-DD,YYYY-MM-DD e.g. 2022-12-28,2022-12-29,2022-12-30.

Deployment Instructions

You can use this connector in the following cases:

1. Obtain a api key either from RapidAPI or Blobr.
2. Add the step in to your Power Automate Flow
3. Enter in your api key and select your endpoint
4. Pass in the value of your domain, you can also pass in a full email address however we only need the domain