Showing results for 
Search instead for 
Did you mean: 
Level 10

Create 5,000 items in SharePoint List from Tweets

This flow create 5,000 item in SharePoint List from Tweets.

For creating large items SharePoint List, and testing it.


The reference flow by the blog post "Create SharePoint Large Lists using Microsoft Flow (no-code solution)"

Thank you Srinivas VarukalaAugust.


My Flow hack some points from the blog post.

1. Turn Off the Setting - 'Split On' of trigger, for reduce flow run count.

2. Turn On the Setting - 'Single Instance', for restrict parallel flow runs.

3. Calcurate Items Count from Min ID and Max ID, for remove all items.

4, Check count of items at a time of each flow, for reduce check count.





1. Trigger - Twitter - When a new tweet is posted.

  Setting - Split On = Off

  Setting - Single Instance = On.

2. Action - Variable - Initialize variable.

  Name = COUNT

  Type = Integer

  Value = 0

3. Action - SharePoint - Get Items = Get items - min

  Order by = ID asc

  Top count = 1

4. Action - SharePoint - Get Items = Get items - max

  Order by = ID desc

  Top Count = 1

5. Action = Variable - Set Variable

  Name = COUNT

  Value = add(sub(outputs('Get items - max').body?.value[0].ID, outputs('Get items - min').body?.value[0].ID),1)

  Configure run after = is successful, has failed

6. Condition = COUNT is greater than 5400


  6.1 Action = Terminte - Terminate

    Status = Scceede

7. Apply for each

  Select an output from previous steps = value

  7.1 Action = SharePoint - Create Item

    Site address = <your site rul>

    List name = <your list name>

    Title = title

    Name = name


-- I'm testing this flow now.



Yoshihiro Kawabata


Helpful resources


Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020


Flow Community User Group Member Badge

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


New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!


Microsoft Learn

Learn how to build the business apps that you need


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 138 members 4,076 guests
Please welcome our newest community members: