Share
Report
28I have a flow that is running once a month, I want to create a new table in a worksheet each month. When I add a "Create Table" it's adding a table to the correct worksheet but the column names are coming in as "Column 1, Column 2... ect." I am adding data to the column names field in power automate in these two fashions but neither of them are adding the names of the columns as the headers when the new table is created. How can I fix this?
Device Name;Office;First Seen;Last Seen;Sent Data;Received Data;Total Data Usage
or
{
"columns": [
{
"name": "Device Name",
"type": "string"
},
{
"name": "Office",
"type": "string"
},
{
"name": "First Seen",
"type": "date"
},
{
"name": "Last Seen",
"type": "date"
},
{
"name": "Sent Data",
"type": "number"
},
{
"name": "Received Data",
"type": "number"
},
{
"name": "Total Data Usage",
"type": "number"
}
]
}
"columns": [
{
"name": "Device Name",
"type": "string"
},
{
"name": "Office",
"type": "string"
},
{
"name": "First Seen",
"type": "date"
},
{
"name": "Last Seen",
"type": "date"
},
{
"name": "Sent Data",
"type": "number"
},
{
"name": "Received Data",
"type": "number"
},
{
"name": "Total Data Usage",
"type": "number"
}
]
}
Categories:
All responses (
Answers (
