cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Do Until Help

Hey everyone!

 

So I'm trying to build a flow that is triggered whenever someone uploads a file to a folder in Sharepoint. If that file has been in the folder for 48 hours and hasn't been touched, Flow will send an email to the person who uploaded it letting them know it hasn't been worked on. 

 

Is there a way to set something like this up? I had a feeling that "Do Until" was what I was looking for, but I'm not sure how to use it.

 

Niko

4 REPLIES 4
Super User
Super User

Re: Do Until Help

HI @Anonymous,

 

 

 

DelayActions.PNG

Why don't you use the Delay or Delay until actions?

Anonymous
Not applicable

Re: Do Until Help

Ok, but I only want the alert to go out if the item is not modified. The idea is that if someone adds a file to this folder in sharepoint and no one works on it for 48 hours, it sends an alert to the person who uploaded it that it has not been worked on. 

 

But if someone does work on the file, I don't want that alert to go out. 

 

Is this possible?

 

Niko

Community Support Team
Community Support Team

Re: Do Until Help

Hi @Anonymous,

 

Do you want to send out a reminder email if the uploaded file has not been modified after 48 hours of its creation?

 

I have made the following flow for test. It is triggered by When a file is created (properties only), then a Delay action for 48 hours. Following by a Condition to check if the file has not been touched for 48 hours.

 

The code in the condition is:

@greaterorequals(triggerBody()?['Modified'], addhours(triggerBody()?['Created'],48))

 

If yes, send an email to the file creator.

 

Please check the following image for more details:

1.PNG

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Do Until Help

Hello @v-yamao-msft!

Thank you for your suggestion. I tried testing it by reducing the time to 10 minutes. 

2018-09-17.png

Unfortunately, whenever I try testing it, the condition keeps coming back as "false", meaning that, as far as it can tell, the file has been modified within the last 10 minutes.

 

2018-09-17 (2).png

 

I'm not sure why this isn't working though. Did I mess up the code somehow when I changed it to "minutes" instead of "hours"?

 

Niko

 

P.S. I'm not sure if this matters, but I should note that I am uploading a file to the folder on Fieldglass, not creating a brand new one. I don't know if this matters though. The flow still runs when I upload a file, but it seems to still be registering that the file is being modified within 10 minutes of being uploaded.

 

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,858)