• 9 Responses

    How to set a Scheduled Flow to run on specific dates of a month?

    Introduction

    In this blog, we are going to learn how to set a scheduled flow to run on specific dates of a month.

    We all know that a scheduled flow can be set to run based on a day/weekly at a specific time of the day. But making it run only at particular dates of a month is challenging and many of us don’t know that.

    Example

    Suppose we have a scheduled flow which we want to run on 1st, 15, 16, 30, or 31 (end of the month) and repeat every month.

    Solution

    Step 1:  Use Recurrence as a trigger and set it to trigger once a day, click on three dots to the left then click on Settings.

    Step 2:  Set the trigger conditions to
    @or(equals(utcNow('dd'), '01'),equals(utcNow('dd'), '15'),equals(utcNow('dd'), '16'),equals(utcNow('dd'), '30'),equals(utcNow('dd'), '31'))

    That’s all, now your flow will run at 1st, 15th, 16th, 30th, or 31st every month at 10 am.

  • Subscribe
    Notify of
    guest
    9 Comments
    Oldest
    Newest Most Voted
    Inline Feedbacks
    View all comments
    Marcos Ramírez
    Marcos Ramírez
    1 year ago

    Hi! Thank you for your post!
    I’m getting this erro message with this solution: “Cannot read properties of undefined (reading ‘properties’)”
    Everything is like your post. Can you help me?

    Nebulaa Blogger
    Editor
    1 year ago

    Hi, have you entered the formula correctly on the trigger condition?

    @or(equals(utcNow('dd'), '01'),equals(utcNow('dd'), '15'),equals(utcNow('dd'), '16'),equals(utcNow('dd'), '30'),equals(utcNow('dd'), '31'))
    
    Bar
    Bar
    1 year ago

    Hi, I followed this but seems to be not working. I’m getting the same error.

    Tyrone
    Tyrone
    1 year ago

    Yes, it still returns an error for me too.

    RAJESH R
    RAJESH R
    1 year ago

    I set this formula in the Trigger condition, but it doesn’t appear to function and states “Cannot read properties of undefined (reading ‘properties’)”.

    Ankit
    Ankit
    1 year ago

    HI,
    If we only wantsto run our flow on the last day of every month, then what would be the trigger condition ?

    Kim
    Kim
    1 year ago

    I am also getting this error “Cannot read properties of undefined (reading ‘properties’)”. Please help!
    Thank you!

    Stuart
    Stuart
    1 year ago

    This hard code is not working for me…also i need to run job on every month on specific date and it should check for specific email in the inbox from start of month to the current triggering date? Is there any search query for this problem..Thanks

    Filip
    Filip
    11 months ago

    Hey, I stumbled on the same business case couple of days ago and this command worked for me:
    @equals(int(formatDateTime(utcNow(),’dd’)),23)
    First, I convert a date to number and then make a equal sign. Don’t remember to add “@” at the very beginning

WANT QUICK D365 IMPLEMENTATION?

Let started with our D365 Quickstart package and get onboard within 7 days!

I'M INTERESTED!
LATEST POSTS
© Copyright 2024 Nebulaa IT Solutions LLP. All Rights Reserved.
Download
Brochure