Have you ever wanted to create a flow in Microsoft Flow where you trigger on multiple lists? So if you create a list item in one list or an other you want to trigger the flow?
Well with Microsoft Flow you can do this.
I’m going to start with a manual trigger and the creation of 2 variables.
- Status
- Last Trigger Time
I’m setting the status to Started and the Last Trigger Time to the current time.
Now fro each trigger a Do Until loop that will stop when the status has been set to Complete.
Then inside each Do Until a Condition that check for the status.
Now within the Yes branch I’m starting with a Get items collection all the items from a list since the last trigger time.
Followed by the process that I want to implement for my list. In my case I’m just sending an email.
Once the process is complete I set the status to Complete, ending all my branches in my flow
This is an easy away to reduce the number of runs in your flow. I would probably only implement this for simple processes as I like to keep my processes simple. But if you are running out of runs this could be an options to reduce the number of runs and therefore save on licence costs
Interesting way of using Flow. What I don’t get is the manual trigger action. How do the multiple lists trigger this one Flow?
Hi Jeroen, the manual start is purely to get the process started. I could even imagine that we auto restarted the flow after completion.
This is a great concept, but I’m not sure how I see you taking action on more than one list. I Would it be in the two DoUntil branches? What if I wanted to act on a ‘list of lists’?
M.
Hi Marc,
The do until are there to catch the list triggers. Potentially if you wanted to run the same process for each item on each list you could just set some variables with the relevant list item details and implement the process after the do untils.
Nice.
I use do/until tips for reduce the number of run of flow.
My flow.
When each day 6:00am, do/until – do something each 10 minutes.
therefore, I can reduce the number from 4464 runs to 31 runs per month.
4464 = 31 days * 24 hours * each 10 minutes.
31 = 31 days.