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

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

via François on SharePoint, Office 365 and more technologies http://bit.ly/2MejfXR

François Souyri
French native Sharepoint Consultant living in London. A crossway between a designer, developer and system architect. Prefers stretching the limit of out-of-the-box features rather than breaking them into code. When not working with Microsoft Sharepoint François is often found on Web2.0 News sites and related social networking tools.

This article has been cross posted from sharepointfrancois.com (original article)

Categories: Work Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

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

%d bloggers like this: