Unanswered

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.

Categories:

Using flows

Screenshot 2023-1...

I have the same question (0)

All responses (10)

Answers (1)

VictorIvanidze 13,073 on at

Like (0)

Report

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

Was this reply helpful? Yes No
denisbalakirev 40 on at

Like (0)

Report

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

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Please show the "Do until" options: Count and Timeout.

Was this reply helpful? Yes No
denisbalakirev 40 on at

Like (0)

Report

I can see only 1 option there

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

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

Was this reply helpful? Yes No
denisbalakirev 40 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,073 on at

Like (1)

Report

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/

Was this reply helpful? Yes No
denisbalakirev 40 on at

Like (0)

Report

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

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Рад помочь! 😉

Was this reply helpful? Yes No
denisbalakirev 40 on at

Like (0)

Report

Many thanks!
Спасибо!🙂

Was this reply helpful? Yes No