Do until and delay

[kenneth0596]

Hi,

Im building a flow that sends out email with options. The response will update a column named Extension Request in SharePoint. Ideally, it will keep sending out email everyday until Extension Request is not equal to "Maybe". 

My problem is that the loop only works if user responded to the initial email. 

I need it to run everyday until the condition is met.  Any help is greatly appreciated! 

[MattWeston365]

Hi @kenneth0596 what's the trigger for the Flow?

If it's a data source which I can query I'd be quite tempted to have a separate Flow which is checking for a response on a daily basis. But that depends if you're grabbing the data from somewhere.

[ScottShearer]

@kenneth0596 :

The short answer is that you can't change the behavior that you have described - the Flow will pause until a response is received.

Here is an alternative approach:

1. Use a recurrence trigger that runs once a day
2. Use a SharePoint Get Items action to retrieve items from the list
   1. Use a filter so that only items where extension request is not equal to Maybe are returned
   2. You could use a condition instead but an OData filter is a better idea
3. Loop through the items returned and send an email with a link to the SharePoint item and instruct the user to update it.