How to add a recurrence action into it?

[Anonymous]

Hey everybody,

I've just got a simple question and I hope there's somebody who's able to respond to it.

There you can see the image of my own flow created by myself.

What I like to achieve:

- If I enter the data into PowerApps, it should be created a record at a given time first (DatePicker).

- There should be an interval to select when the next record will be created (in 1 Month for example) (Dropbox with Days, Weeks,   Months, Years).

- Now the most important: A RECURRENCE. -------------- The record should be created each month until end of time.

What has already been achieved:

- As you can see in the screenshot, I do create a record at a given time but only once. The action won't be triggered any longer.

My question:

How do I integrate the recurrence option? It's not possible because it always reports: You cannot use this trigger as an action.

Thanks for your help!

Regards,

ThePowerAppsGuy

[Pstork1 · Accepted solution]

Since an individual instance of a flow only runs for 30 days maximum before timing out its not feasible to build recurrence into the original flow itself.  So I would create the record as you are doing now and set the date when the follow-up should take place.  Then build another flow that runs with a recurrence trigger at whatever cycle time you want.  When that trigger fires have it check each of the records to see if the date is within the time period since the last recurrence.  If it is update the date and do the action you want completed (create a new record).

[Anonymous]

Hey @Pstork1,

Thanks for your respond.

May you give me a short example?

[Pstork1 · Accepted solution]

Do what you normally do to create a record and put a date/time field in it for the date when you want to add the new record.  Then this is what the simple recurrence flow looks like

It triggers based on a schedule.  For testing I set mine for every 10 minutes.  Then it gets the records from the list.  You can add an OData query to limit what is returned.  

Then you compare the date field to see if its within the time period since the flow last ran (10 minutes ago in my case) but not still in the future.  If it is then perform your action, if not do nothing or report some value.

[Anonymous]

Hey @Pstork1,

Thank you so much for your effort. I really appreciate it. You‘ve really helped me a lot.

[Anonymous]

Hey @Pstork1,

I'm trying and trying and trying but I don't get it anyhow.

Would you mind telling me what you have already done in the images you've sent me?

I mean in the Condition... What is in DueDate for example or in addMinutes?

I'm very unfamiliar with Power Automate and I hope there's still a way to explain further.

Still many question marks remain.

Maybe I see the picture as a whole even better if I see more details from your side.

Really appreciate your support.

Thanks so much!

[Pstork1 · Accepted solution]

1. My trigger is set to run the flow every ten minutes.  You can change the duration and the interval.  I set mine that way for testing.  I suspect yours will be set to run once a day at a specific time.
2. Next I do a Get Items on the list to get all the Items in the list.  As I mentioned in the advanced options you can add a OData filter to limit which items are returned.  I wouldn't do that until you get your flow working the way you want it to.

1. In the next section I have a condition that checks whether DueDate falls within the last 10 minutes, in other words since the last time my flow ran.  Due Date is just a Date/Time field I added to my list to keep track of when something should be done.  When I create the item in SharePoint I set the due date for a time about 15 minutes in the future.  That's when this recurrence flow will find it and act on it.  In your case that would be 30 days out (or whatever you want for an interval).  The condition checks that by subtracting ten minutes from UTCNow() and adding 1 minute to UTCNow().  If Due Date is Greater than UTCNow() -10 and less than UTCNow() +1 then it falls within the last ten minutes.  There is no SubtractMinutes function so you use AddMinutes() with a negative number to subtract 10.  There is also an AddHours() and AddDays() function depending on the time frame you are checking.  In your case it would be AddDays()
2. In my case I'm just using a Compose in the Yes and No for Troubleshooting.  This is where you would do whatever actions you want to do when the item is reviewed. in your case I think it was create a new record with a DueDate in the future.

[Anonymous]

@Pstork1 

Thanks so much for your detailed response. Gonna check it out...