Send an e-mail notification the last working day of the month 02-28-2022 08:04 AM - last edited 02-28-2022 15:03 PM

[Michal]

Power Automate flow which sends an e-mail notification the last working day of the month, except holidays.

Simple and quick to implement. Rady to use. Enjoy!

Assumptions:

• Monday is the first day of the week
• Saturday and Sundays are non-working days

If you want to contribute and make it even better (i.e. including holidays or set start weekday to different), use my GitHub repository. 

Above is just s simple version of specific need in the following posts:

Flow Schedule - make flows run when you want - get more scheduling options

Find Days in a month and end of the month   

[AntoniOrfila]

Hello!

I am trying to run the flow, but it says that it cannot read properties, do you know how to fix that?

Thanks!

[Michal]

@AntoniOrfila  can you post a screenshot showing the error, please?

[TravisBartel]

Hi Michal! I really like this flow. Thank you for providing it. I'm trying hard to understand the logic and I think I'm almost there.

Thanks again!

Travis

[PandaciucVasile]

@Michal  Here is the error that was reported above:

[Maz0102]

Hi Michal

Thank you for providing the attachment for this.

I tried to run a test but I get the following error as per screenshot

are you able to advise please?

[hagemaru123]

Hi @Michal , thank you for your template, however, May I ask, why it shows "No input" 

[VladMihai]

Hello!

Can someone help me with the formulas for each step of this flow?

I don't know why, but I can not use the zip file uploaded here.

Thank you!

[AusarZ]

Hi guys,

First of all, Michal thank you for this wonderful flow. Guys, in order to tackle this issue you have to remove 'Terminate' condition under 'If No'. It solved the problem for me.

@Michal , if I may ask you, could you please make a flow that will send files in OneDrive for business folder to a certain email on the last working day of the month? The folder only containts photos and one xlsx file. After files sent, photos should be removed except xlsx file.
So basically, your flow already does the main part, just need add some extra steps.
Thank you

[Michal]

Hi @AusarZ 

Of course, I can.

But you can do it also. Just use the "List files in folder" action from OneDrive for Business, and for each file use the "Get file content" action to collect all file content. You can collect them in an array of objects. 

When you collect all, you just need to use "Send an Email (V2)" from the Office 365 Outlook connector to send them. 

Finally, you can use the information you gathered at the beginning and use the "Delete file" action from the OneDrive connector to delete the files you want. 

Let me know how far you come and ask for help if you have any issues. 

If you want me to deliver the solution for you instead you learn how to make it and doing it yourself, you can contact me directly.

/Michal