Hi @Jpineiro,
Microsoft Flow handles time in UTC format, so in order to make the flow to work with your local timezone, here we take use of the addhours function to add the UTC offset.
For example, in Beijing TimeZone, the formula below would Add 8 hours.
Addhours(triggerBody()?['DateTimeReceived'],8,'HH:ss')
Please find your timezone and then modify the 8 with the UTC offset for your timezone.
So the whole formula for the condition should be:
@and(
GreaterOrequals(
Addhours(triggerBody()?['DateTimeReceived'],UTCoffset,'HH:ss'),
formatDateTime('19:00','HH:ss')
),
lessOrEquals(
Addhours(triggerBody()?['DateTimeReceived'],UTCoffset,'HH:ss'),
formatDateTime('21:00','HH:ss')
)
)
Regards,
Michael
