cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philbud
New Member

Flow send email from shared mailbox based on time of day

Hi all, I'm new with power automate and cannot find a way to make my flow work.

I want to configue a flow that will email an automatic email reply when a shared mailbox receive new email between 14h00 and 20h00.

I have no problem getting my flow to work without time condition.

Can someone help me with that part? Pretty sure that my value is not correct on far right of condition.

Thanks

 

Screenshot_1.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Instead of 02, please make it 2. Goal is to perform Integer comparison.

 

4h check may not be needed.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

3 REPLIES 3
PrasadAthalye
Community Champion
Community Champion

Here is how I think you could do it... 

  • Add 3 actions. One that converts to your timezone and returns output in AM\PM format
  • Second one Converts to your timezone and returns hour portion.
  • Third one Converts to your timezone and returns minutes portion.

PrasadAthalye_0-1623375139393.png

 

Now Check 4 condition...

 

  • Condition 1 - Check if AM\PM converted time contains PM
  • Condition 2 - Check if 2nd Converted time of hour is greater than or equal to 2.
  • Condition 3 - Check if 2nd Converted time of hour is less than 8.
  • Condition 4 - Check if 3rd Converted time of minutes > 0...

If all condition satisfy, send email

 

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
philbud
New Member

Thanks for your help but I'm getting an error when I'm testing.

Check flow and condition below.

I was testing condition to send email between 2am and 10am.

 

I didn't put the 4th condition in your message because I don't understand why I would need it.

 

Error that i'm getting:

Unable to process template language expressions for action 'Condition' at line '1' and column '3283': 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

 

Screenshot_26.jpgScreenshot_25.jpgScreenshot_24.jpg

Instead of 02, please make it 2. Goal is to perform Integer comparison.

 

4h check may not be needed.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,302)