Answered

scheduled cloud flow to send email every 10th Business Day

(1) Share

Report

Posted on by vgulati4

Hello, I want to send an email from Outlook on the 10th business day of every month. I am not able to create a scheduled cloud flow that identifies the date and sends the email.
I created a table in an excel file in OneDrive and applied the formula for the 10th Business Day and thought that Flow could pick the date from there and on that day it will send the email, but am not able to do that as well.
Kindly help in creating this flow either using excel to pick the date from there or without excel.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

David- 1,254 on at

Like (1)

Report
This might work:
Schedule your flow to run every 10 days
Then do a compose action to return the current day with the expression:
formatDateTime(utcNow(),'dddd')
Add a Switch action with the output of the Compose action
In your switch, set up two conditions for Saturday and Sunday
In the Saturday switch, add a delay of two days
In the Sunday switch, add a delay of one day
And the default will be if it is a weekday
Although, I don't think this will get you exactly what you want since when you encounter a Saturday and it waits two days, the workflow will still run 10 days from the Saturday instead of 10 days from the Monday. But this might be as simple as you can get without making things too complicated.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (2)

Report

Hi @vgulati4 ,

Could you please tell me:
Have you saved the working days you need to send mail in Excel?
You can create a schedule flow that runs once a day and add a Condition to see if the date in the Excel table is equal to today.
If the dates are equal, the email will be sent, and if the dates are not equal, the process ends.

I have made a test for your reference:

Best Regards,
Levi

Was this reply helpful? Yes No
vgulati4 on at

Like (0)

Report

Hello @v-liwei-msft many thanks for the solution, I was trying to do the same but wasn't able to do it as I was not able to add expression in the condition. your explanation and snapshots helped me complete it. Really appreciate your help/support. Many thanks, sir.

Was this reply helpful? Yes No