Unanswered

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

(0) Share

Report

Posted on by KarinaFerreira

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Riyaz_riz11 3,860 Super User 2025 Season 2 on at

Like (1)

Report

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

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.

Was this reply helpful? Yes No
Riyaz_riz11 3,860 Super User 2025 Season 2 on at

Like (0)

Report
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

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.

Was this reply helpful? Yes No
KarinaFerreira 20 on at

Like (0)

Report

Hello @Ahammad_Riyaz

I have my flow created with these connectors.

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

Thankssss

Was this reply helpful? Yes No
Riyaz_riz11 3,860 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

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

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.

Was this reply helpful? Yes No