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

In the upcoming video tutorial, we will delve into the process of reading sizable Excel files from SharePoint using the Graph API within Power Automate. While Power Automate does offer out-of-the-box (OOTB) actions to facilitate Excel file reading, these actions come with a significant constraint – they are limited to only 250 records. Additionally, from a performance standpoint, they do not stand up to scrutiny, often lacking in efficiency. Hence, our emphasis will be on utilizing the Graph API, a more robust and efficient solution, to seamlessly access and process larger data sets from Excel files in SharePoint.

#PowerAutomate #GraphAPI #SharePoint #ExcelIntegration #DataProcessing

Some of the Actions Config from Power Automate flow:-
Get Access Token :-
URI
https://login.microsoftonline.com/TenantID/oauth2/v2.0/token
Body
grant_type=client_credentials&client_id=AppID&client_secret=SecretValue&scope=https%3A%2F%2Fgraph.microsoft.com%2F.default

Get Site ID:-
URI
https://graph.microsoft.com/v1.0/sites/purpledemo.sharepoint.com:/sites/RPPoC?$select=id
Headers
Authorization bearer @body(‘Get_Access_Token’)[‘access_token’]

Get Excel File:-
URI
https://graph.microsoft.com/v1.0/sites/@body(‘Get_Site_ID_2’)[‘id’]/lists/ListID/drive/root:/@outputs(‘Get_file_properties’)?[‘body/FilenameWithExtension’]:/workbook/worksheets/Sheet1/tables/Table1/rows
Headers
Authorization bearer @body(‘Get_Access_Token’)[‘access_token’]