Answered

Get Items within Do Until

(0) Share

Report

Posted on by denisbalakirev

Hello everyone,

I've spent a week searching for a solution to my problem and haven't found anything yet. Maybe you can help me find a solution.

So, about my Flow. The trigger for the flow is a button in Power Apps. From Power Apps, I pass the necessary information to filter a SharePoint list. After filtering this list, I find users in one of the columns and send them an email.

Details: New data is constantly coming into the list, and one of the filtering conditions (

formatDateTime(addDays(utcNow(), -1), 'MM/dd/yyyy')

) is the date (always the previous day). The flow should run for 12 days, so I put everything in a Do Until Loop. Everything works as intended on the first iteration. But the next day, for some reason, the Do Until doesn't trigger the list filtration again and uses the previous data. As a result, the column with the user's email remains empty, and the flow ends with an error.

Screenshots for better understanding below.

Screenshot 2023-1...

All responses (10)

Answers (1)

denisbalakirev 40 on at

Like (0)

Report

Re: Get Items within Do Until

Many thanks!
Спасибо!🙂
VictorIvanidze 12,207 on at

Like (0)

Report

Re: Get Items within Do Until

Рад помочь! 😉
denisbalakirev 40 on at

Like (0)

Report

Re: Get Items within Do Until

Thank you for pointing out on important setting.
I will test it and let you know the result.
Verified answer

VictorIvanidze 12,207 on at

Like (1)

Report

Re: Get Items within Do Until

PT1H means one hour. It's the source of your problem.
See https://nishantrana.me/2022/06/06/change-limits-in-do-until-control-power-automate/
denisbalakirev 40 on at

Like (0)

Report

Re: Get Items within Do Until

ok, got it. Usually counter equal to 12 bit I lowered the value for testing purposes.
VictorIvanidze 12,207 on at

Like (0)

Report

Re: Get Items within Do Until

You have shown Settings.
I mean the things you will see if you click "Change limits"
denisbalakirev 40 on at

Like (0)

Report

Re: Get Items within Do Until

I can see only 1 option there
VictorIvanidze 12,207 on at

Like (0)

Report

Re: Get Items within Do Until

Please show the "Do until" options: Count and Timeout.
denisbalakirev 40 on at

Like (0)

Report

Re: Get Items within Do Until

@VictorIvanidze Hi,
Get Items function, Filter Query field. Get Items located in Do Until Loop.
VictorIvanidze 12,207 on at

Like (0)

Report

Re: Get Items within Do Until

Hi @denisbalakirev,
where exactly in you flow you are filtering items by date? In which action?