web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Do until loop with the...

Power Automate

Answered

Do until loop with the lastdate of my API call

(0) Share

Report

Report

Posted on by Robin1988

249

Hello all,

I'm struggeling to get the do until loop right. Because it uses everytime the same date so de loop is not working correctly.

The problem is that I have to give an date at the beginning and the second time that loop runs the date has to change to:

last(body('Parse_JSON')?['items'])?['createDate'] of very run that it makes.

Do you get the point? So how can make an variable of the date. Loop stops if nextPageUrl is equal to null.

Thanks in forward

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Robin1988 :

Do you want to set dynamic time in this expression:

If so, you could try:

1\Set a variable outside the do until loop and give it an initial time

2\Replace the time in the expression(marked with a red square) with the variable initialized in the first step

3\Add a 'set variable' under 'Parse_JSON' in the do until loop to assign a value to the variable set in the first step

last(body('Parse_JSON')?['items'])?['createDate']

Best Regards,

Bof

Was this reply helpful? Yes No
Robin1988 249 on at

Like (0)

Report
Copy link

Link copied!

Thank you for looking into my problem, that's it!

Was this reply helpful? Yes No

Join the conversation