Explain how to trigger only once per month on last calendar day of month

[hkusulja]

How to trigger on last calendar day of month (some months have 28days, sometimes 29, some 30 and some 31 days) ?

Explain what will happen on:
Start: 2019-01-31
Interval: 1
Frequency: Month

will it run on 2019-02-28 , or it will not be run in February at all ?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: f9106dab-3f70-7388-1be0-da02b5728827
• Version Independent ID: 13613736-0637-a17c-f5b4-a1476e294032
• Content: Schedule and run automated tasks and workflows with Azure Logic Apps
• Content Source: articles/connectors/connectors-native-recurrence.md
• Service: logic-apps
• GitHub Login: @ecfan
• Microsoft Alias: estfan

[AmanGarg-MSFT]

@hkusulja Thank you for the question! We are investigating this and will get back to you shortly.

[PramodValavala-MSFT]

@hkusulja That's a good question!

Azure Logic Apps is set to replace Azure Scheduler as mentioned in this official announcement. So, the Recurrence Trigger supports the advanced examples mentioned here.

The UI doesn't show it but you can include them in your workflow JSON directly.

So, for your use case, your trigger JSON would be something like this

"triggers": {
    "Recurrence": {
        "recurrence": {
            "frequency": "Month",
            "interval": 1,
            "schedule": {
                "monthDays": [-1]
            }
        },
        "type": "Recurrence"
    }
}

[hkusulja]

@PramodValavala-MSFT I am using Azure Logic App, with trigger -

   "triggers": {
            "Recurrence": {
                "recurrence": {
                    "frequency": "Month",
                    "interval": 1,
                    "startTime": "2019-01-01T02:00:00Z",
                    "timeZone": "Central European Standard Time"
                },
                "type": "Recurrence"
            }
        }

Now I see your example, i have modified it to:

 "Recurrence": {
                "recurrence": {
                    "frequency": "Month",
                    "interval": 1,
                    "schedule": {
                        "minutes":[0],
                        "hours":[16],
                        "monthDays":[-1]
                    }
                },
                "type": "Recurrence"
            }

Please confirm this is only UI / designer issue, and it will be fixed? can you document that this is only code option?

[PramodValavala-MSFT]

@hkusulja Yes. Its just that the UI doesn't support these advanced schedules yet.
Also, if you were wondering, the JSON schema for the Logic App confirms the validity of these options.

Please feel free to open a feature request on UserVoice for enhancing the UI to support these use cases.

As for the docs, we will assign this issue to the content author to further investigate and update accordingly.

[hkusulja]

yeah, please update the docs, and say this options is only through code/JSON , not in Designer / UI... tx

[ecfan]

@hkusulja & @PramodValavala-MSFT, thank you! I've created a work item on our doc backlog for triage.

#please-close

[MWielen]

Hi,

I want to set recurrence schedule to 1st of month starting at 03:00 AM
When I try to save the following JSON only monthDays is saved but hours and minutes is lost when saving.

"triggers": {
"Recurrence": {
"recurrence": {
"frequency": "Month",
"interval": 1,
"schedule": {
"minutes":[0],
"hours":[3],
"monthDays": [
1
]
},
"startTime": "2019-08-01T03:00:00Z",
"timeZone": "UTC"
},
"type": "Recurrence"
}
}

Result after saving:

"triggers": {
"Recurrence": {
"recurrence": {
"frequency": "Month",
"interval": 1,
"schedule": {
"monthDays": [
1
]
},
"startTime": "2019-08-01T03:00:00Z",
"timeZone": "UTC"
},
"type": "Recurrence"
}
}

What should I do? Thanks!

[strategywise]

Is there an option that would allow for something like 'run on the 8th business day of the month' ? Not sure if the above methods would work in this case?

[ecfan]

@kevinlam1 & @derek1ee, could you please help answer the question from @strategywise about how to set a recurrence to something like "8th business day of the month"? Thanks!

GitHub issue: #26707

[ecfan]

This update is live:

https://docs.microsoft.com/azure/logic-apps/concepts-schedule-automated-recurring-tasks-workflows#run-once-at-last-day-of-the-month

https://docs.microsoft.com/azure/connectors/connectors-native-recurrence (inline example under Workflow definition)