Unanswered

When an Email arrives, create a calendar entry accounting for holidays and business days/time

(0) Share

Report

Posted on by JL-14062200-0

Hello all,

I am new to Power automate however, I would like to create a flow that whenever a new email arrives, it creates an outlook calendar entry based on the date of the first email in the chain of that specific email. It also needs to account for business days and holidays. So far, I have created a flow that creates a calendar entry that accounts for business days and holidays, however, it is only based on the date of the newest email in the chain, not the oldest. Also, it doesn't account for business hours (8am to 5pm). Please see the flow below:

Compose 'Date': utcNow()

 
Compose 'Dates': From: Range (0,365)
                 Date: formatDateTime(addDays(outputs('Date'), item()), 'yyyy-MM-dd')
                 Day:  dayOfWeek(addDays(outputs('Date'),item()))
 
Filter Array 'ExcludeHolidays': From: Value from 'Filter out Saturdays and Sundays'
                                Left: Output from 'Holiday Days'
                                Right: item()['Date']
 
Compose 'Target Date': body('ExcludeHolidays')[outputs('Days_to_Add')]['date']
 
 
I am new to the coding language so any visuals or code that I can copy/paste would be great, thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

André Arnaud de Cal... 679 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

What is the actual business requirement you try to solve here? I'm not able to understand what you want to achieve. When an email arrives, you want to look for older messages in that thread and based on the oldest email you want to create a calendar item in the past? In case that date was in the weekend or on a bank holiday, what date do you then want to use for that email?
In case the first email in the chain arrives, then you might already create the calendar item. Why are you then searching for the oldest email and try to insert a duplicate calendar item?

Was this reply helpful? Yes No
JL-14062200-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

For the business, every email request sent to a specific email address is required to be due 10 business days from the date of receipt. This initial email can be sent to another department before ours, therefore we would get it, say, 3 business days from the date of initial receipt. I have put an example below:

Initial email (Rec'd June 8, 2026) -> sent to budgeting (June 9, 2026) -> sent to my department (June 11, 2026).

(10 Business days from June 8, 2026, is June 23, 2026, if we account for a local holiday on the 19th)

I would like it, if possible, that when the email chain arrives to my department, a calendar entry is made for June 23, 2026, and not June 26, 2026, which it would have normally done according to the trigger "When an email arrives."

Was this reply helpful? Yes No