I'm trying to build a Gmail Auto-reply flow that starts every Thursday at 5PM and ends Friday at midnight.
This is what I have so far. All I could figure out was how to add Friday as a condition and I'm not sure it will work.
Can somebody hell me out?
Email trigger provides "Received Time" output, date+time the email was received. THis is at least in Outlook, I haven't tested gmail trigger yet. If not supported, you can apply utcnow() expression instead.
As soon as you get the date, you can convert date&time format. This thread provides valuable info about how to do it:
Hope this helps
I have made a test on my side and please take a try with the following workaround:
Within Condition box, click “Edit in advanced mode” and type the following formula:
The flow works successfully as below:
"When a new email arrives" trigger runs everytime an email arrives to your gmail account. Once executed, the excellent flow example provided by @v-xida-msft evaluates the condition, and if match applies the corresponding action.
If I were you I would test it. Once te flow is declared and saved, you can inspect all its executions by going to the Flow Run History.
Hope it helps
Date&time related functions are defined here
There are also date&time related action blocks that have been recently released:
You can also manipulate date format. THere are several threads in this community with examples, one of the most recent ones is this one:
Yes, I understand how conditional actions work, thank you. What I'm not being able to figure out is how to make the condition be:
When new email arrives AND it's Thursday after 5pm until Friday 23:59 THEN send automated reply.
The part I'm having trouble with is Thursday after 5pm until Friday 23:59. I don't think it's possible to achieve this with the date format because it point to a specific point in time (29 of December 2017, for example), and I need it to have recurrence every week.
Can you just tell me if this is even possible to do in Microsoft flow?
I'm just looking for an educated guess, so I don't have to read through pages and pages of documentation only to find that I wasted my time. That's all I'm asking for. Thank you.
In order to verify that a time matches a certain time range, there is an excellent thread here explaining how to do it
For day of the week verification, @v-xida-msft has provided a very useful proposal
So, I guess you have to combine both verifications to have your flow up and running
Hope this helps
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications