Рет қаралды 2,615
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...