Share via

Power automate work flow sending birthday email a day later

Teddy Anyanga 0 Reputation points
2024-09-25T23:55:20.7733333+00:00

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.Screenshot 2024-09-26 095356

Any Idea how I can correct this will be appreciated.

Regards

Teddy

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,753 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
593 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 26,331 Reputation points Microsoft Vendor
    2024-09-27T09:34:44.48+00:00

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.