I want to share a tips to record data from PowerShell script to Excel by Microsoft Flow.
Summary:
When a PowerShell script run with data, add the data to Excel file on OneDrive for Business.
Use Scenario:
Record data to Excel from PowerShell.
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 PowerShell script
{ "Name": "a", "Value": 100 }
Request Body JSON Schema for trigger
{ "type": "object", "properties": { "Name": { "type": "string" }, "Value": { "type": "integer" } } }
PowerShell script
$endpoint = "" $payload = @{ "Name" ="A" "Value" =100 } Invoke-RestMethod -Method Post -Uri $endpoint -Body (ConvertTo-Json $payload) -ContentType 'application/json'
Please set $endpost to HTTP POST URL of trigger.
Excel file prepare before run the PowerShell script
1. Enter "Name" to A1 cell
2. Enter "Value" to B1 cell
3. Format as table
Regards,
Yoshihiro Kawabata
Solved! Go to Solution.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
44 | |
38 | |
30 | |
28 | |
26 |