Unanswered

Creating a Do Until Loop based on file being updated?

(0) Share

Report

Posted on by AmeerKhan

Hi I've got the following flow set up working. It's reading the 'modified by' column to identify who to email after 28 days to send an email to update their CV. However I'd like to make a 'Do Until' loop which can send fortnightly reminder emails if they ignore the initial one. I'd like to either stop the loop when said person has replied to the email or automatically stop the loop if it can see the 'Modified by date' is now < 2 weeks old (this is subject to how frequent the reminders should go out).

Question 1: I'm aware flows are limited to 30 days so am I working at my limit here and therefore can't set a loop to remind every 2 weeks?

Question 2: What's the best approach if I did want to set up a loop in the aforementioned way?

Capture 3.PNG

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

MJain 2,450 on at

Like (0)

Report

Re: Creating a Do Until Loop based on file being updated?

Hi @AmeerKhan ,

If you can modify the flow to recurring flow and set it to run on daily basis ? This way you can pull up all the records from sharepoint which are modified today .

Thanks

Was this reply helpful? Yes No
AmeerKhan 15 on at

Like (0)

Report

Re: Creating a Do Until Loop based on file being updated?

Hi so, based on your advice what I did was kept that flow as it was since that will start a timer from the initial file deposit and email after 28 days which is exactly what I need.

I created a second flow to apply in the same folder which recurs daily and checks the following:
Modified <= UTCNow(),-45 days which should check if it's more than 6 weeks old. If it is more than 6 weeks old it should send daily reminders until they've updated it, otherwise do nothing. Does this sound like it should work?

Ideally I'd want to say 'Modified by date' instead of UTCNow, if that's possible in the expression.

Was this reply helpful? Yes No