Using CRON Expression in Logic Apps Recurrence

Question

Using CRON Expression in Logic Apps Recurrence

R, HemanthKumar 40

Hello,

I am creating a logic app and workflow using Python, where we get the schedule as a cron expression via the UI. Can someone suggest how to use cron expressions in logic apps recurrence? If it is not possible, is there a way to change the cron into recurrence?

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-27T07:22:45.1133333+00:00
@R, HemanthKumar Thanks for reaching out.

Can you share more details what do you mean by "creating a logic app and workflow using Python". Do you mean that you are creating the logic app in VS code designer or designer in azure portal?

Can someone suggest how to use cron expressions in logic apps recurrence

You cannot specify the corn expression in logic app. But you can use the Recurrence trigger to specify a schedule for your workflow to run.

For example, if you want your workflow to run every day at 5 PM UTC, you can set the Recurrence trigger to run your work flow as per your business need. For example for every day and set the time to 5 PM UTC.

Here is an example of how you can set up the Recurrence trigger in your Logic App:

In the Logic App Designer, add a new Recurrence trigger.

Set the Interval to 1.

Set the Frequency to Day.

Set the Time zone to UTC.

Set the Start time to the date and time you want your workflow to start running.

Set the Hours to 17.

Set the Minutes to 0.

In case if you have the CORN expression then you can use ncrontab or this to know what does your CORN expression means if you are not familiar with CORN expression. Now at the logic app Recurrence trigger end you can configure the output as per the different property that I have specified above.

Hope the above clears things up and let me know if you have any queries or concerns.
R, HemanthKumar 40 Reputation points

2023-11-27T08:15:50.8866667+00:00
Hi @MayankBargali-MSFT Thank you for your response. I'm writing Python code to create a logic app and workflow. Please see the image attached. For example, if a user specifies that he wants to execute a job at 11:32AM every day, the UI will return the cron expression cron(32 11? * * *). Is there a way to programmatically convert this cron expression to an Azure recurrence? or Is it possible to define cron expression directly in the workflow?
FYI, We will get N number of requests from UI . We need to automate creating logic apps recurrence as per cron expression.
I want to convert *cron(32 11 ? * * ) -->

"recurrence": { "frequency": "Day", "interval": 1, "schedule": { "hours": [ "11" ], "minutes": [ 32 ] }, "timeZone": "India Standard Time" },

Accepted answer

0 additional answers

Your answer

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-27T07:22:45.1133333+00:00

@R, HemanthKumar Thanks for reaching out.

Can you share more details what do you mean by "creating a logic app and workflow using Python". Do you mean that you are creating the logic app in VS code designer or designer in azure portal?

Can someone suggest how to use cron expressions in logic apps recurrence

You cannot specify the corn expression in logic app. But you can use the Recurrence trigger to specify a schedule for your workflow to run.

For example, if you want your workflow to run every day at 5 PM UTC, you can set the Recurrence trigger to run your work flow as per your business need. For example for every day and set the time to 5 PM UTC.

Here is an example of how you can set up the Recurrence trigger in your Logic App:

In the Logic App Designer, add a new Recurrence trigger.

Set the Interval to 1.

Set the Frequency to Day.

Set the Time zone to UTC.

Set the Start time to the date and time you want your workflow to start running.

Set the Hours to 17.

Set the Minutes to 0.

In case if you have the CORN expression then you can use ncrontab or this to know what does your CORN expression means if you are not familiar with CORN expression. Now at the logic app Recurrence trigger end you can configure the output as per the different property that I have specified above.

Hope the above clears things up and let me know if you have any queries or concerns.
R, HemanthKumar 40 Reputation points

2023-11-27T08:15:50.8866667+00:00

Hi @MayankBargali-MSFT Thank you for your response. I'm writing Python code to create a logic app and workflow. Please see the image attached. For example, if a user specifies that he wants to execute a job at 11:32AM every day, the UI will return the cron expression cron(32 11? * * *). Is there a way to programmatically convert this cron expression to an Azure recurrence? or Is it possible to define cron expression directly in the workflow?
FYI, We will get N number of requests from UI . We need to automate creating logic apps recurrence as per cron expression.
I want to convert *cron(32 11 ? * * ) -->

"recurrence": { "frequency": "Day", "interval": 1, "schedule": { "hours": [ "11" ], "minutes": [ 32 ] }, "timeZone": "India Standard Time" },

Answer 1

MayankBargali-MSFT 70,936 Moderator

@R, HemanthKumar Thanks for clarifying in more details.

Unfortunately no there is no out of box feature that can help you in your use case as CORN is directly not supported right now in reoccurrence trigger. You can always pass your feedback to feedback forum if this is something you want to see/support in reoccurrence trigger in future.

What you can do in your python code is build your custom solution and break the CORN expression to get the {second} {minute} {hour} {day} {month} {day-of-week}based on your user input and dynamically build the recurrence template that logic app understands which has frequency, Interval etc. that I have shared previously so it creates the reoccurrence trigger.

Feel free to get back to me if you have any queries or concerns.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

R, HemanthKumar 40 Reputation points

2023-11-27T08:38:16.3033333+00:00

@MayankBargali-MSFT Thank you very much!! I'm already working on converting CRON to Azure recurrence. I just wanted to confirm whether or not Azure's built-in support for it exists so that I can avoid creating my own solution.
Shrey Mishra 20 Reputation points

2024-01-22T11:05:22.96+00:00

Hii @MayankBargali-MSFT , Is this possible to take cron expressions dynamically from database and use it to schedule task for scheduled time using azure functions???, If please tell a basic work flow.

Share via

Using CRON Expression in Logic Apps Recurrence

0 additional answers

Your answer