Power Automate – Excel – How to create Table and Read the Contents Dynamically from SharePoint?

In this video I will explain how to create a table and read an Excel sheet contents dynamically from SharePoint. Following are the expressions I used in this video Get Document Library Id https://graph.microsoft.com/v1.0/site... SharePoint document library id first(body('Filter_array'))?['id'] Get Excel Filename Id https://graph.microsoft.com/v1.0/site...{outputs('SharePoint_document_library_Id')}/root/children?$select=id,name&$filter=startswith(name, '@{triggerOutputs()?['headers/x-ms-file-name-encoded']}') Excel Id first(body('Send_an_HTTP_request_2')?['value'])?['id'] Excel Filename first(body('Send_an_HTTP_request_2')?['value'])?['name'] Get Excel Used Range https://graph.microsoft.com/v1.0/site...{outputs('SharePoint_document_library_Id')}/items/@{outputs('Excel_Id')}/workbook/worksheets('Sheet1')/usedRange(valuesOnly=true) Excel Value Range last(split(body('Send_an_HTTP_request_3')?['address'],'!')) Create Table https://graph.microsoft.com/v1.0/site...{outputs('SharePoint_document_library_Id')}/items/@{outputs('Excel_Id')}/workbook/worksheets('Sheet1')/tables/add Excel Table Id body('Send_an_HTTP_request_4')?['id'] My other video I mentioned about One Drive & Excel link is below.    • Power Automate – Excel – How to create Tab...