Answered

Loop stuck subtracting days

(0) Share

Report

Posted on by Murphys110

I'm trying to modify steps that work well in another flow, that loops through adding days until I get to the next Sunday (for example).

In the new instance I'm trying to use the loop to subtract one day until it finds the most recent Monday (see screenshot below). When the flow runs, it is stuck in this loop. Not sure what I'm doing wrong, aside from changing Sunday to Monday, and making it a negative 1 instead of positive, everything else is identical to the working steps. Thanks for any insights.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Murphys110 on at

Like (0)

Report
Copy link

Link copied!

I think I know what I did... the 'store the result into' should "CurrentDateTime" or it's always starting from today.... will test and update here.

Was this reply helpful? Yes No
eetuRobo 4,549 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Your %Monday% -variable is dateTime format and not weekdays. So it never is actually 'Monday' but a date like 28/02/2024 7:00:00PM.
Use DayOfWeek function on that too.

And to make the loop go backwards add %LoopIndex% variable that you decrease every loop and use that in the add time Add -field

You can copy paste this code to your PAD if you want:

SET LoopIndex TO 0
DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime
LOOP WHILE (CurrentDateTime.DayOfWeek) <> ($'''Monday''')
DateTime.Add DateTime: CurrentDateTime TimeToAdd: LoopIndex TimeUnit: DateTime.TimeUnit.Days ResultedDate=> CurrentDateTime
SET Monday TO CurrentDateTime.DayOfWeek
Variables.DecreaseVariable Value: LoopIndex DecrementValue: 1
END

Was this reply helpful? Yes No
Verified answer

Murphys110 on at

Like (0)

Report
Copy link

Link copied!

That did it... 🙂 Pasting screenshot of the very simple fix... feeling like Homer Simpson... d'oh!

Was this reply helpful? Yes No