cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Memorable Member
Memorable Member

Tips - Record data from PowerShell script to Excel by Microsoft Flow

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

2018-08-12 (1).png 

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

2018-08-12 (2).png 

Regards,

Yoshihiro Kawabata

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @yoshihirok,

 

Thanks for your sharing.

 

Best regards,

Alice

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @yoshihirok,

 

Thanks for your sharing.

 

Best regards,

Alice

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (8,062)