Tips - Record data from Command Prompt to Excel by Microsoft Flow

(0) Share

Report

Posted on by yoshihirok

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

2018-08-12 (1).png

Enter or paste a sample JSON payload for sending from a Commnd

{
 "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

2018-08-12 (2).png

Regards,

Yoshihiro Kawabata

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (1)

Report

Re: Tips - Record data from Command Prompt to Excel by Microsoft Flow

Hi @yoshihirok,

Thanks for your sharing.

Best regards,

Alice

Was this reply helpful? Yes No