I need help with a flow app. I want to be able to take the current time, round that time up to the nearest quarter hour and then add 7 minutes to that time. Then I want to delay the rest of my flow until that time comes. For example: Current time is 15:18, I want it to round up to 15:30 and then add 7 minutes to make it 15:37. I then want to delay the rest of my flow until that time.
mul(add(int(first(split(string(div(float(outputs('Minutes')),15)),'.'))),1),15)
Same approach using formatDateTime
addMinutes( formatDateTime( outputs('Compose'), concat( 'yyyy-MM-ddTHH:', mul( div( int(formatDateTime(outputs('Compose'), 'mm')), 15 ), 15 ) ) ), 15 )
As @ChrisSM correctly noted, the above expression fails with 1 digit as the minute.
Therfore an update:
My try:
Cut off the seconds and reduce the minutes to the previous full quarter, then add 15 minutes (no issues with next hour/day/month etc).
addMinutes(
concat(
slice(outputs('Compose'), 0, 14),
mul(
div(
int(slice(outputs('Compose'), 14, 16)),
15
),
15
)
),
15
)
Thank you! I ended using a combo of if statements to accomplish this.
Hello, @Anonymous!
If you have already posted your idea to the Flow Community Ideas Forum then you need to post the URL to your idea’s thread as a reply to this thread and then "Accept as Solution" on that reply so other users may vote for your Flow Idea and identify the information easily.
Thank You!
-Gabriel
Flow Community Manager
Hi @Anonymous,
I am afraid that there is no round function can be used in flow currently, you may consider submitting a request on Flow Ideas forum for this function:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Besides, you may try to use the function if to return the value you want according to the existing time. Please take this doc for more details about the function:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
Best regards,
Mabel Mao
Churchy
6
Chriddle
4
Super User 2025 Season 1
stampcoin
4