Problem with do untill field is populated

[mallow]

Hello,

I am building flow which when status is changed wait for a field to be filled in, if not send reminder after 2 weeks

here is my flow:

here is problematic part:

M first idea was to check if column 'Invoice Number' has been changed, if no send reminder.

My second idea which I have found on this forum was to wait untill field 'Invoice Number' empty is empty:

Both my ideas does not work. I would appriciate any help

[PrasadAthalye · Accepted solution]

@mallow 

You can achieve this with 2 flows. 

In the current flow which is set to trigger on every update, you are already checking if the status is ready.  Create a new column called reminder date in the list. When the status is ready, you can populate the reminder date by adding 2 weeks to the current time and update the list item. Also, if you find that the 2nd column which you are looking for if changes or not,  is updated, you can wipe out the reminder date. 

Now You can design 2nd Flow that runs every day with a Schedule trigger. In this flow, you can filter all the records where the Reminder date matches today's date. If yes, check the value of the column changed. If it has not changed, send a reminder email else do not send an email. If you wish to remind again after 2 weeks, update the reminder date to 2 weeks again.