Hi! I am creating a Recurrent flow to send reminders everyday at a specific hour stored as a value in Excel Online.
The reasoning is having a table that based on a column that enables the reminder (list of items = 'On', 'Off'). I have got different recipients, one in each row, and I want to send a reminder at 10:00 AM each day during THEIR time zone. To do this I convert what would be 10:00 AM in their time zone to CEST/CET which is my time zone in a new column in the Excel table. So basically I end up with a table with a name and the hour of my day in which the reminder should be sent.
- List rows in a table
- Apply to each
- hh:mm in Column X equals Current hh:mm (no seconds considered as the flow runs every minute of the day)
How do I create this condition of comparing a 'time' (hour+minute - no date) value of an Excel Online value with the current 'time' to trigger an action when match is TRUE?
I've gone for the
To get the hour and minutes you can do the following:
For hour and minutes in 24 hour clock
Hi @abm , thanks for your reply. Based on your input on how to align times from different sources for an 'is equal to' condition, is this correct?
Recurrence = 1 minute
List Rows Present in a Table
Apply to Each > Excel 'Value'
Error message displayed:
InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '15180': 'In function 'formatDateTime', the value provided for date time string 'My Column' was not valid. The datetime string must match ISO 8601 format.'.
Time in the Excel file formatted as time: