Send an e-mail notification the last working day of the month

@Michal Thank you.  It is a bit hard to follow at the first but thank you for sharing this Power Automate workflow.  Very much appreciated.

Hi @PandaciucVasile 

Strange. I imported it into a new environment and I had no issues. Try to import it from GitHub once more or just set the schedule once more and save the flow. Maybe it needs a refresh. 

Hi @TravisBartel 

It took me a while to understand the logic which I needed to build but I managed. So you should be able to understand it as well. 

If you have any questions, just ask but be patient as I am not fast in answering.  

Hi @Maz0102 

This is expected behavior if you run this flow more than 4 days before the end of the month.

There is a trigger condition that limits the flow to run only 4 days in a month even if it is scheduled to run every day.

This reduces the call actions in Power Automate.

Of course, if you remove the trigger condition, the flow will run.  

/Michal

Hi @hagemaru123 

Because the condition is not met (DateCountDown was not equal to the current date), probably

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

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

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!

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

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?