Unanswered

Loop Condition on Date

(0) Share

Report

Posted on by FlashDota

I have a For Loop and this date, if the next date in the for loop is August I want to hit the back arrow, if it is December I want to hit the forward arrow 3 times for example. I can create a column in Excel with the month of each date in number format. How can I implement this logic in the Loop Condition

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

MichaelAnnis 5,727 Moderator on at

Like (2)

Report

I assume you already know how to Extract the text from that element displayed in your screenshot, so I'm continuing from there.

This process will evaluate the 2 each time and only click the arrow once upon each valuation, then re-evaluate. That way it's > or < 0, not extra lines of code trying to decipher if the 2 are part of the same year or not.

Let's say that variable is %ElementText% and your next Loop date is a date variable set to %NextLoopDate%.

Also %NextLoopDate% should be on the 1st of the month in this case, if not, convert %NextLoopDate% to Month/01/Year so it can be compared equally against %ElementDate%

Label Click Arrows
Convert Text to Datetime %ElementText% custom format MMMM yyyy to %ElementDate%

If %NextLoopDate% > %ElementDate%

'click right arrow

GoTo Label Click Arrows 'this will basically loop us until %NextLoopDate% = %ElementDate%

Else(IF) %NextLoopDate% < %ElementDate%

'click left arrow

GoTo Label Click Arrows 'this will basically loop us until %NextLoopDate% = %ElementDate%

End(IF)

Good luck

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

I personally prefer not using labels, so my take on this would be more like this:

Loop While %NextLoopDate% <> %ElementDate%

Convert Text to Datetime %ElementText% custom format MMMM yyyy to %ElementDate%

If %NextLoopDate% > %ElementDate%

'click right arrow

Else(IF) %NextLoopDate% < %ElementDate%

'click left arrow

End(IF)

End (loop)

But otherwise your solution does the trick!

Was this reply helpful? Yes No