Subscriptions Custom Calendar

Anonymous · ‎04-23-2020

Hi

When creating a subscription I would like reports to send an email based on a custom calendar. For example rather than sending on the 2nd day of each month, I want to be able to send on the 2nd working day of a month (taking into account wekends and French public holidays). Any ideas?

Greg_Deckler · ‎04-23-2020

Power Automate.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎04-23-2020

Can you give me some hints as to the connectors/actions I would need?

I'm envisaging storing my bespoke calendar in sql server (and have set up the connection in Power Automate).

Would you bypass the subscrptions function alltogether, and create a custom email notificaton sending the URL of the report based on a data condition being met i.e. today's date = specificed work day date?