Skip to main content
Community site session details

Community site session details

Session Id : X+lZmYnpUSmLMlYvpSS42M
Power Automate - Building Flows
Unanswered

Scheduled Cloud Flow: Finding Last Friday of Every Month, Error Message "Cannot read properties of undefined (reading 'properties')"

Like (0) ShareShare
ReportReport
Posted on 19 Dec 2022 12:34:27 by 21

I've tried to set up a scheduled cloud flow to run on the last Friday of every month as below:

 

Screenshot 2022-12-19 122940.pngScreenshot 2022-12-19 122955.png

 

@And(lessOrEquals(int(utcNow('dd')),int(addDays(addToTime(startOfMonth(utcNow()),1,'Month'),-1,'dd'))),greaterOrEquals(int(utcNow('dd')),int(addDays(addToTime(startOfMonth(utcNow()),1,'Month'),-7,'dd'))))

 

However, the result on testing is:

Screenshot 2022-12-19 123027.png

 

I've tried refreshing connections and setting a new flow up, but can't solve it. Any help much appreciated!

  • FG33 Profile Picture
    21 on 04 Jan 2023 at 14:41:40
    Re: Scheduled Cloud Flow: Finding Last Friday of Every Month, Error Message "Cannot read properties of undefined (reading 'properties')"

    @v-jefferni Thanks. I've tried your suggested actions but still get the same error. Is the example time string compatible with timezone I've selected?

     

    Screenshot 2023-01-04 143528.png

  • v-jefferni Profile Picture
    on 30 Dec 2022 at 07:18:24
    Re: Scheduled Cloud Flow: Finding Last Friday of Every Month, Error Message "Cannot read properties of undefined (reading 'properties')"

    Hi @FG33 ,

     

    Is this flow working now? Have you tried the suggestions in my reply?

     

    Best regards,

  • FG33 Profile Picture
    21 on 21 Dec 2022 at 12:09:24
    Re: Scheduled Cloud Flow: Finding Last Friday of Every Month, Error Message "Cannot read properties of undefined (reading 'properties')"

    Sure, screenshots of flow below. If I remove the trigger condition, it works fine. 

     

    Screenshot 2022-12-21 120648.pngScreenshot 2022-12-21 120730.png

     

     

  • v-jefferni Profile Picture
    on 20 Dec 2022 at 06:20:24
    Re: Scheduled Cloud Flow: Finding Last Friday of Every Month, Error Message "Cannot read properties of undefined (reading 'properties')"

    Hi @FG33 ,

     

    The expression is correct. Could you please share the entire flow? Or you can try and:

    1. fill up the time zone paramter;

    2. recreate the actions those of other connectors.

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2