Why there is no such thing as a free lunch (with Microsoft Flow;-)

Creating a flow for a client recently, where we have to loop through 8,000+ Excel rows, check the values in some columns and import them or skip into a SharePoint list.

The issue was the … well, Flow doesn’t let us read more than 5,000 entries by default. And increasing that limit is not allowed.

Flow action to get Excel sheet

Except, that one of our developer accounts was able to break that limitation(!).

It turns out that the free Flow license limits the threshold to 5000 whereas buying a Flow Plan 2 license allowed us to go over the threshold.

Flow license

Here you go, now you know how to break one limit: buy the license!

This blog post is also useful to highlight some other limitations:

Microsoft Flow – This is the limit! – My Microsoft SharePains

One comment

Leave a Reply

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