Unanswered

Simple Do Until doesnt work

(0) Share

Report

Posted on by yannikl

I want Power Automate to create a table which contains the times of 6:00 until 18:00 (with 10 Minute gaps) and the current date once a day. So I created this flow:

And the Do Until of the Minutes work perfectly fine, I get the table starting from 10.08.2021 6:00, then 10.08.2021 6:10, 6:20, 6:30, 6:40, 6:50, 7:00 and so on. But for some reason it wont stop at 18:00. It just continues to 19:00, 19:10, 19:20 ... then to 20:00, 20:10 etc. and never ends. Can anyone find my mistake?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Because it is doing it until the hour is 18

You should do something like:

If hour equal 18, do flow, if not, nothing

Was this reply helpful? Yes No
yannikl 4 on at

Like (0)

Report
Copy link

Link copied!

But I want it to do the flow until the hour is 18. I want every Hour and every 10 Minutes until 18:00 to be in the table. I tried something with a condition before but that didnt work either. It just created a Gap between 17:40 and 18:50 for some reason

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You should do something like:

If hour equal 18, nothing , if not, flow

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The problem can also be as you get the hour

Was this reply helpful? Yes No
yannikl 4 on at

Like (0)

Report
Copy link

Link copied!

Thats exactly what ive tried. I had a condition if Hour is less than 18: do the flow, if not: nothing. But that didnt help either. So I think youre right, it must have something with the Hour variable. But I have no idea what I am supposed to do

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I have a bot to say Happy B day and what I do is this:

1. Current time
2.Convert Time
3. Compose -> converted time
4. Compose2 ->
first(skip(split(outputs('Compose'),','),1)) -> Day
4. Compose3 ->
first(skip(split(outputs('Compose_2'),' '),1)) -> Hour
5. Compose4 ->
first(skip(split(outputs('Compose_2'),' '),2)) -> Min

Then,

If: compose3 = 18, do nothing, else, do flow

Was this reply helpful? Yes No