web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Birthday Email sent a ...
Power Automate
Unanswered

Birthday Email sent a day earlier instead of the actual schedule day

(1) ShareShare
ReportReport
Posted on by AlfaE 7

Hi all,

 

I'm creating a flow where users will receive an automate email on their birthdays.

The flow is working however it's sending a day earlier instead of actual schedule.

 

So the date I pull is from my sharepoint below

 

AlfaE_0-1694050876239.png

test example that was just did, look at Title 'Alfa' the DOB stated is as Sept 8 however as per below I received on 7 Sept

 

AlfaE_1-1694051013599.png

 

 

The flow is as below, I'm not sure if I need to amend the Compose Input,formatDateTime?

 

AlfaE_3-1694051231363.png

 

 

AlfaE_2-1694051069969.png

 

 

Seeking help please!

Categories:
General topics
I have the same question (0)
  • trice602 Profile Picture
    trice602 15,402 Super User 2025 Season 2 on at

    Hi @AlfaE ,

     

    The issue is the server time for UTC now in your compose.  I don't know what time it is but you can try a couple of times adding some hours to see the results for today's date.  Here's what the expression looks like:

     

    addHours(formatDateTime(utcNow(),'MM-dd'),8)

     

    trice602_1-1694055486027.png

     

    Because you are 8 hours ahead of UTC and your server time may be even farther ahead, when this runs as 8 AM, it's actually just before midnight the previous day and the root cause.  So, experiment with the compose adding some hours to get the desired results and this expression should solve this for you.

     

     

     

     

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft on at

    Hi @AlfaE ,

     

    Maybe it's caused by the time zone in flow.

    Could you share the outputs about 'Dob' and formatDateTime(utcnow(),'MM-dd') ?

    You can try to add a compose before the condition to store the outputs of Dob.

     

    Best Regards,

    Wearsky

  • AlfaE Profile Picture
    AlfaE 7 on at

    Hi @trice602

     

    Thank you for suggestion, unfortunately your suggestion doesn't seem to work.

    Did a test flow and the email didn't come in.

    Also waited for the schedule time and didn't receive the email either.

     

    AlfaE_0-1694068446988.png

     

  • trice602 Profile Picture
    trice602 15,402 Super User 2025 Season 2 on at

    Understood.  Review the output of your compose and see what the date is and modify adding hours to get to the correct date.

     

     

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

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans