Automate Flow for a certain time period

[ads_uk]

Hi all,
I'm very new to Automate and have attempted to create a Scheduled Flow, which runs, but does not switch off when I've set it to.
It's recurrence is for every day at half past the hour, with "Current Time"

Output1: greaterOrEquals(formatDateTime(utcnow(),'HH:mm'), '08:30')
Output2: lessOrEquals(formatDateTime(utcnow(),'HH:mm'), '18:30')

My conditions is:
And Current Time is equal to Output1
Current Time is equal to Output2

The flow runs, but as soon as it hit's 16:30 it just continues to run.

I've did find this trigger condition @And(GreaterOrequals(convertTimeZone(utcnow(), 'UTC', 'Central Standard Time', 'HH:mm'),formatdatetime('08:30','HH:mm')),lessOrEquals(convertTimeZone(utcnow(), 'UTC', 'Central Standard Time', 'HH:mm'),formatdatetime('18:30','HH:mm')))
  but when even testing it I get an error "Cannot read properties reading ID" and
"Request to Azure Resource Manager failed with error: '{"error":{"code":"WorkflowTriggerHistoryNotFound","message":"The workflow xxxxx trigger 'Recurrence' history 'null' could not be found"

Can someone please point me in the right direction

[CraigStewart]

I'm not sure if that can be set in the trigger itself it's not something I've ever looked at - however you can stop the flow from running after the trigger with a condition

This will run down the Yes side of the condition until 8pm
On the No side adding the Terminate action with a reason of cancelled will stop the flow progressing any further.

Not exactly what you were after as you'll still have a "Cancelled" flow every 30 minutes

[CraigStewart · Accepted solution]

Looking at your trigger I decided to have a play around and got it working with a similar set up for my timezone

I'm in the UK and set a trigger up for every minute and a local time to finish a few minutes later

This is the code I used in the trigger condition

@And(greaterOrEquals(convertTimeZone(utcNow(), 'UTC', 'GMT Standard Time', 'HH:mm'), '09:00'), lessOrEquals(convertTimeZone(utcNow(), 'UTC', 'GMT Standard Time', 'HH:mm'), '20:19'))

It's currently 20:21 and the flow is no longer triggering

[eyau]

Hello,

I've tested your trigger condition a few times and it should work. Syntax is 100% correct. The condition you originally used should not have worked though because Output 1 and Output 2 can only output "true" and "false", so comparing it to "Current Time" should have failed it each time.

If the trigger condition continues to show the error message "Request to Azure Resource Manager failed with error: ..." then the flow must be corrupted in some way. To fix this, go to your flow options and click "Save As" to save it as a new flow copy.

@And(greaterOrequals(convertTimeZone(utcNow(),'UTC','Central Standard Time', 'HH:mm'),formatDateTime('08:30','HH:mm')),lessOrEquals(convertTimeZone(utcnow(), 'UTC', 'Central Standard Time', 'HH:mm'),formatDateTime('18:30','HH:mm')))

-E

[ads_uk]

Thank you both.

[ads_uk]

Despite this running successfully yesterday, the first attempt this morning failed. 
Error 429 - "Your operation has been throttled."

Within PowerBI I can see that there was a scheduled refresh set by a colleague in the US, which ran from 9pm to 12:30am BST.

I know that there is a limit of 8 refresh attempts, but at what time does this reset?
Is it a specific time each day or 24hours after the first/last refresh within Automate/BI?

[KarenFen1]

Hi @CraigStewart ,

Thank you for your post.  It sounds like just what I need.  I'm also in the UK.  I'm trying the trigger condition you've described, but within the timeframe of 10:45 - 11:00, so my trigger condition reads:

@And(greaterOrEquals(convertTimeZone(utcNow(), 'UTC', 'GMT Standard Time', 'HH:mm'), '10:45'), lessOrEquals(convertTimeZone(utcNow(), 'UTC', 'GMT Standard Time', 'HH:mm'), '11:00'))

It has just sent me a couple of emails. 😊 Thank you!  I'll test it again now since it is past 11:00 am and will then set the times as we want them.

I wasn't aware that I had to convert UTC to GMT Standard Time.  Thank you for that insight.  That could explain why I couldn't previously get it to work.  I'm just wondering, does the converter here take into account the daylight saving changes? 

Thank you in advance.

Karen