Skip to main content

Notifications

Power Automate - General Discussion
Answered

Flow Condition query

(0) ShareShare
ReportReport
Posted on by 254

I am playing with a simple flow to evaluate a client's birth date from my clients table. If the month and day = today(), I want a birthday reminder. 

I have a test client that I use. I changed the client's birth date to 30 August simply to test the flow. 

Nothing happened. 

 

I checked the flow results - see screen shot 2 - I changed the birth date to 30 August. Where does the 29 August come from?

 

  • Hilda Steyn Profile Picture
    Hilda Steyn 254 on at
    Re: Flow Condition query

    Thank you. I appreciate the time you took to give such a comprehensive answer. 

  • Verified answer
    Linn Zaw Win Profile Picture
    Linn Zaw Win 2,982 on at
    Re: Flow Condition query

    @hildasteyn 

    29 August comes from the actual data stored in the database. When you create a "Date only" column with default "User local" time zone adjustment setting, the system stores the value as UTC date in the database. Since the time zone setting of the user who saved the record is GMT+3, the 30th Aug is stored as "1969-08-29T21:00:00Z" (UTC time) in the database. Read more details in this blog post.

     

    How are you getting the client data where the Date of Birth month and day = today()?

    If you are querying all the data and get the Month and Day part, you need to convert the time zone of the value before getting the Month and Day part. You can either do it with the action or expression.

    LinnZawWin_1-1693418291931.png

     

    But for this scenario like the Date of Birth, I would recommend deleting and re-creating the column (if possible) as Time Zone Independent so that you don't have to worry about such an issue.

    LinnZawWin_0-1693416527592.png

     

  • Chriddle Profile Picture
    Chriddle 7,395 on at
    Re: Flow Condition query
    equals(utcNow('MM-dd'), formatDateTime('2023-08-30', 'MM-dd'))
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,115 on at
    Re: Flow Condition query

    Hi @hildasteyn 

     

    Could u show the flow design ?

     

    Also where you are storing the data , in dataverse table ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard