Answered

1 day before first Thursday of month

(0) Share

Report

Posted on by cheezy

148

I would like to trigger a flow to run the day before the first Thursday of the month (to send power BI documentation to meeting participants)

Any ideas on how this can be achieved?

thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cheezy ,

Could you please share more details? Which trigger would you like to use? Is it a scheduled flow which runs once a month the day before the first Thursday?

If this is the case, then you need to use a Recurrence trigger with a trigger condition:

@equals(addDays(startOfMonth(utcNow()), mod(sub(10, dayOfWeek(startOfMonth(utcNow()))), 7), 'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))

Best regards,

Was this reply helpful? Yes No
cheezy 148 on at

Like
a
(0)

Report
Copy link

Link copied!

hi Jeffer
Yes a scheduled flow which runs once a month the day before the first Thursday would be fine
when i set up the trigger i get an error:

Request to Azure Resource Manager failed with error: '{"error":{"code":"WorkflowTriggerHistoryNotFound","message":"The workflow '1c175f6e-6101-43ce-9dd0-a49e78f6a3a0' trigger 'Recurrence' history 'null' could not be found."}}'.

this is the trigger:

with your condition

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cheezy ,

You cannot test the recurrence trigger where has trigger condition like this. The condition set makes the flow run only on Wednesday but today is Friday, so it doesn't run at all. The error is saying no run history is found in the server.

You can remove the trigger condition and check the date in Compose, see if it's May 8th.

Best regards,

Was this reply helpful? Yes No