Power Automate - Excel - How to create Table and Read the Contents Dynamically from OneDrive?

In this video I will explain how to create a table and read an Excel sheet contents dynamically from OneDrive?
Here are the expressions I used in this video.
Rest API for finding the Excel ID and Filename
graph.microsof..., '@{triggerOutputs()?['headers/x-ms-file-name-encoded']}')
Expression Excel Filename
body('Parse_JSON')?[0]['name']
Expression Excel Id
body('Parse_JSON')?[0]['id']
Rest API for finding the Excel Used Range
graph.microsof...{outputs('Excel_File_Id')}/workbook/worksheets('Sheet1')/usedRange(valuesOnly=true)
Expression for getting the used range values
last(split(body('Send_an_HTTP_request_4')?['address'],'!'))
Rest API for Create Table
graph.microsof...{outputs('Excel_File_Id')}/workbook/worksheets('Sheet1')/tables/add
Parse JSON 2 Schema
{
"type": "object",
"properties": {
"@@odata.context": {
"type": "string"
},
"@@odata.type": {
"type": "string"
},
"@@odata.id": {
"type": "string"
},
"style": {
"type": "string"
},
"name": {
"type": "string"
},
"showFilterButton": {
"type": "boolean"
},
"id": {
"type": "string"
},
"highlightLastColumn": {
"type": "boolean"
},
"highlightFirstColumn": {
"type": "boolean"
},
"legacyId": {
"type": "string"
},
"showBandedColumns": {
"type": "boolean"
},
"showBandedRows": {
"type": "boolean"
},
"showHeaders": {
"type": "boolean"
},
"showTotals": {
"type": "boolean"
}
}
}
My Blog
mydevexperienc...
Check out my other video Create Table & Read Excel contents from SharePoint link is below.
• Power Automate - Excel...

[@aleixvazquezsanchez9284]

Thank you for you video!! In step 1, the HTTP request only gets the file ID when a file is created in the OneDrive root. Do you know how to get the ID file when it is created within an OneDrive folder?

[@abm4975]

Hi Aleix If you have a particular folder then you need to change the HTTP endpoint accordingly. In my example I was using the root folder. Thanks

[@RiyaTech21]

Hii ajith Can you explain the how to write expressions,to do the excel operations in power automate

[@abm4975]

Hi Vinny What expression you looking for? There is no such expression specific to Excel. All expressions are like functions. It should work for any data whether its Excel, SharePoint, Dynamics or SQL. What specific operation you looking for? Thanks

[@RiyaTech21]

Like mathematical operations with data in excel

[@abm4975]

Hi Vinny Have a look at this doc docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference See Math functions sections. If you want to run an Excel script from Power Automate please see this doc. docs.microsoft.com/en-us/office/dev/scripts/tutorials/excel-power-automate-manual Thanks

[@RiyaTech21]

@@abm4975 Tq