Microsoft Flow – Create a trigger on multiple SharePoint lists! SharePoint Designer workflows can’t do this!

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

 

Interested in more of these kind of tricks, Sign up to the Triad webinar today.

Advertisements

5 thoughts on “Microsoft Flow – Create a trigger on multiple SharePoint lists! SharePoint Designer workflows can’t do this!

  1. Interesting way of using Flow. What I don’t get is the manual trigger action. How do the multiple lists trigger this one Flow?

    Like

  2. 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.

    Like

    1. 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.

      Like

  3. 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.

    Like

Please leave a comment or feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.