Forum Discussion
Copy excel data to SharePoint List using Power Automate
Hello All, I am facing challenges in copying excel data (exist is SharePoint library) to a SharePoint list. I found few articles where it was recommended to create table inside excel to copy, but...
I believe that, with the Graph API call such as the ones below, you are able to select data within the defined range. The example below points to a document in OneDrive, but also a document on SharePoint can be used (with small adjustments to the API call).
https://graph.microsoft.com/v1.0/me/drive/items/{{ITEM_ID}}/workbook/worksheets/{{worksheet_id}}/range(address='A1:A15')https://graph.microsoft.com/v1.0/sites/{{SITE_ID}}/lists/{{LIST_ID}}/items/{{ITEM_ID}}/driveitem/workbook/worksheets/{{worksheet_id}}/range(address='A1:A15')