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.
