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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automatic greeting of ...
Power Automate
Unanswered

Automatic greeting of "Good morning" or "Good Afternoon" or "Good night"

(0) ShareShare
ReportReport
Posted on by 20

Hello,

 

I want to send an email with the header Automatic "Good morning" or "Good Afternoon" or "Good night",  through Power Automate.
Can you help me if there is a possibility in the functions?
In Excel I know the formula:
=IF(TIME(NOW())<=11;"GOOD MORNING";IF(TIME(NOW())>=18;"GOOD NIGHT";"GOOD AFTERNOON"))

 

Thanksss

I have the same question (0)
  • Riyaz_riz11 Profile Picture
    4,191 Super User 2026 Season 1 on at

    Hi @KarinaFerreira ,

     

    If you required to send only  mail then you can use cloud flow and based on the time it will be auto trigger bot.

    FYR

    Ahammad_Riyaz_0-1654604670557.png

    Ahammad_Riyaz_1-1654604705447.png

     

    Here you can able to add one more action send mail, 3 diff bot u can create. Else if you required in Desktop means we can try from there as well.

     

    Regards

    Ahammad Riyaz

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

  • Riyaz_riz11 Profile Picture
    4,191 Super User 2026 Season 1 on at

    Hi @KarinaFerreira ,

     

    If you required in Power automate desktop use this code.

    DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime
    Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''HH''' Result=> FormattedDateTime
    IF FormattedDateTime <= 11 THEN
     Display.ShowMessageDialog.ShowMessage Message: $'''good morning''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
     Email.SendEmail.Send SMTPServer: `` Port: 25 EnableSSL: False AcceptUntrustedCertificates: False SendFrom: `` SendTo: `` Body: $'''''' IsBodyHtml: False
    ELSE IF FormattedDateTime >= 18 THEN
     Email.SendEmail.Send SMTPServer: `` Port: 25 EnableSSL: False AcceptUntrustedCertificates: False SendFrom: `` SendTo: `` Body: $'''''' IsBodyHtml: False
     Display.ShowMessageDialog.ShowMessage Message: $'''good night''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
    ELSE
     Email.SendEmail.Send SMTPServer: `` Port: 25 EnableSSL: False AcceptUntrustedCertificates: False SendFrom: `` SendTo: `` Body: $'''''' IsBodyHtml: False
     Display.ShowMessageDialog.ShowMessage Message: $'''good afternoon''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
    END
    

     

    Ahammad_Riyaz_2-1654605270493.png

     

     

     

    Regards

    Ahammad Riyaz

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

  • KarinaFerreira Profile Picture
    20 on at

    Hello @Ahammad_Riyaz 

     

    I have my flow created with these connectors.

    KarinaFerreira_0-1654605457813.png

    To use this code in the email, he did not accept.
    I believe I did something wrong:

    KarinaFerreira_1-1654605687733.png

     

    Thankssss

  • Riyaz_riz11 Profile Picture
    4,191 Super User 2026 Season 1 on at

    Hi,

     

    Here i was taken currentdatetime and converted to our particular time zone.

    Ahammad_Riyaz_0-1654665080192.png

    Ahammad_Riyaz_1-1654665168010.png

     

    Ahammad_Riyaz_2-1654665203568.png

     

     

    Regards

    Ahammad Riyaz

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 419

#2
Vish WR Profile Picture

Vish WR 314

#3
David_MA Profile Picture

David_MA 260 Super User 2026 Season 1

Last 30 days Overall leaderboard