You’re offline. This is a read only version of the page.
Announcements
1,724
I want to share a tips to record data from Command Prompt to Excel by Microsoft Flow.
Summary:
When a Command run with data on Command Prompt,
add the data to Excel file on OneDrive for Business.
Use Scenario:
Record data to Excel from Command Prompt.
Flow overview:
Trigger : Request - When a HTTP request is received
Action : Excel Online (Business) - Add a row into a table
Enter or paste a sample JSON payload for sending from a Commnd
Share
Report{
"Name": "a",
"Value": 100
}
Request Body JSON Schema for trigger
{
"type": "object",
"properties": {
"Name": {
"type": "string"
},
"Value": {
"type": "integer"
}
}
}Command
PowerShell -Command "& {$URI = \"...\"; $body = ConvertTo-JSON @{ 'Name'= 'C'; 'Value'=21 }; Invoke-RestMethod -uri $URI -Method Post -body $body -ContentType 'application/json'}"Excel
1. Enter "Name" to A1 cell
2. Enter "Value" to B1 cell
3. Format as table
Regards,
Yoshihiro Kawabata
All responses (
Answers (
