Power automate work flow sending birthday email a day later

Question

I set up a cloud workflow in Power Automate.

It is a recurring flow that pulls birthdays from a Sharepoint list and sent birthday emails to Outlook. The time zone is (UTC + 10:00) Canberra, Sydney, Melbourne

The start time is 2024-09-18T12:00:00.000Z

It should run every 7:00 AM

The problem is the birthdays emails are sent 24 hours later. For instance, if the birthday is 26/09/2024, the email will be sent on 27/09/2024. I tried to play around with the start time but it did not work as expected.

Any Idea how I can correct this will be appreciated.

Regards

Teddy

Answer 1

Hi @Teddy Anyanga ,

Welcome to Q&A forum!

Since I haven't received your reply, I have done some research based on the information you provided before. This should be caused by the time zone in the Flow. You can try to use addHours(formatDateTime(utcNow(), 'MM-dd'), -24) to adjust it.I found some similar posts for your references:

https://community.powerplatform.com/forums/thread/details/?threadid=fee5215a-d81d-4f6b-8636-7fd43f640342

https://community.powerplatform.com/forums/thread/details/?threadid=0486a371-740f-48d5-aea1-3c849eb23217

https://community.powerplatform.com/forums/thread/details/?threadid=f07d2d09-b5d1-4079-894f-456d4746922b

If you are still confused at this issue, since Power Automate is not currently supported in the Q&A forum, we recommend that you go to the Power Automate Community to get more targeted support.

Good day!

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.