Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Use Graph API in Power Automate to read large Excel files from SharePoint

Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business processes across a variety of platforms and services. It provides a rich set of features and connectors to help businesses automate their operations with minimal coding. One such common operation is reading Excel files from SharePoint. However, when dealing with large data sets, some inherent challenges arise. In this blog post, we will dive into an efficient method to overcome these challenges using the Graph API.

Check out our video: Use Graph API in Power Automate to read large Excel files from SharePoint

The Challenge

For those familiar with Power Automate’s out-of-the-box (OOTB) actions, you might have stumbled upon its constraints. The most glaring limitation is its capability to read only up to 250 records from Excel files. This might suffice for smaller datasets, but in a business scenario where records can easily go beyond this number, it’s a significant bottleneck. Additionally, these OOTB actions often lack the desired efficiency in terms of performance.

Enter Graph API

The Graph API is Microsoft’s unified programming interface for accessing data across Microsoft 365 services, including SharePoint. By leveraging the Graph API, you can access the contents of Excel files stored in SharePoint document libraries seamlessly and without the aforementioned constraints.

Advantages of Using Graph API

  1. Scalability: With Graph API, the 250 records limitation becomes a non-issue. It’s designed to handle large data sets, making it an ideal solution for businesses with extensive Excel data.
  2. Performance: Graph API offers superior performance in comparison to the OOTB actions of Power Automate. Faster read times and reduced latency mean that workflows run more smoothly and efficiently.
  3. Flexibility: It provides a range of querying options, allowing you to fetch data precisely as per your needs. Whether it’s specific columns, rows, or data based on certain conditions, Graph API can handle it all.

Steps to Integrate Graph API with Power Automate

  1. Register your app with Azure AD: Before you can make calls to the Graph API, you need to register your application in the Azure AD of your Microsoft 365 subscription. This will provide you with an application ID, which will be used to authenticate your requests.
  2. Set permissions: Post registration, assign the necessary permissions for your application to read files from SharePoint.
  3. Create a Power Automate Flow: Begin by creating a new automated flow. Add a trigger based on your requirements. It could be a timed trigger or based on certain events, like when a new file is added to SharePoint.
  4. Add an HTTP action: This action will be used to make a call to the Graph API. Configure the HTTP action to GET the desired Excel data. Here you’ll use the previously obtained application ID for authentication.
  5. Parse the results: The result from the Graph API will typically be in a JSON format. Use Power Automate’s ‘Parse JSON’ action to structure the data. After this, you can use the data as needed in your workflow.
  6. Finalize your flow: Add any additional actions necessary for your business process. For instance, if you’re reading data to update a database or send a report, add these steps accordingly.


In the digital age, where data drives decisions, the necessity to access, process, and utilize large datasets efficiently is paramount. While Power Automate is a powerful tool in its own right, the incorporation of the Graph API enhances its capabilities multifold, especially when dealing with large Excel files in SharePoint.

To sum up, for businesses and individuals looking to harness the full potential of their Excel data in SharePoint, integrating Power Automate with Graph API is not just an option, but a requisite. It ensures scalability, performance, and precision – key components for success in any automated workflow.

#PowerAutomate #GraphAPI #SharePoint #ExcelIntegration #DataProcessing

Latest articles

AxioWorks Newsletter September 2023: An exhilarating month.

30 Sep 2023

Hello Reader, September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
[read article]

The Collaborative Pathway: Bridging Minds in the AI Ecosystem

19 Sep 2023

In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of […]
[read article]

AxioWorks Newsletter August 2023: A month of milestones and innovation.

28 Aug 2023

Hello Reader, September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
[read article]

Use Graph API in Power Automate to read large Excel files from SharePoint

28 Aug 2023

Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
[read article]

From Punch Cards to Python: Still Hitting the Keys in my 50s

16 Aug 2023

I spent the entire weekend writing code, not because of deadlines to meet or million-pound dreams, but for the kick that I still get from doing it. […]
[read article]

AxioWorks Newsletter July 2023: Unveiling AxioWorks’s latest successes and exciting innovations

27 Jul 2023

Hello Reader, We hope this monthly update finds you in good spirits. As always, we are eager to share the latest developments and exciting ventures […]
[read article]

AI and Data: The Symbiosis of Interaction and Accuracy

13 Jul 2023

Artificial Intelligence (AI) has rapidly emerged as a revolutionary technology that fundamentally alters the nature of human-machine interactions. […]
[read article]

AxioWorks Newsletter June 2023: SQList v8 Release, Webinars, and New Product Development

30 Jun 2023

Hello Reader, Greetings to all our valued customers and subscribers! We are thrilled to share some exciting updates and developments with you in this […]
[read article]

Safeguarding Secrets with Secure Strings and Environment Variables in the Power Platform

26 Jun 2023

In today’s interconnected digital landscape, safeguarding sensitive information and maintaining robust security measures is of paramount […]
[read article]

Case study: Streamlining Medical Trial Data Analysis in the Pharmaceutical industry

15 Jun 2023

In the ever-evolving landscape of the pharmaceutical industry, conducting medical trials and analysing the resulting data are critical for the […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter