Answered

Webhook to Excel

Like (1) Share

Report

Posted on 31 Jul 2023 21:31:09 by iesta

Hello! I would like to design a system that is capable of adding a new row to an Excel spreadsheet whenever it receives a webhook request from a system I am building. It needs to take user inputs, save those as strings, send them to the flow, and then the flow needs to create a new row in the spreadsheet and add the information to the correct columns. Your help is greatly appreciated. Please ask for any information you need.

All responses (2)

Answers (1)

iesta 9 on 04 Aug 2023 at 22:01:33

Like (1)

Report

Re: Webhook to Excel

Hey, thanks for taking the time to explain! I really appreciate you taking the time out of your day to help.
Verified answer

abm abm 32,464 Most Valuable Professional on 31 Jul 2023 at 21:54:51

Like (2)

Report

Re: Webhook to Excel

Hi @iesta

Use the below step to create an action step trigger called When a HTTP request is received.

Here above under the body you could pass the data as JSON schema. Add rest of the steps like Add a new row for the Excel sheet. Save Power Automate. It will then generate a public url (See above HTTP POST URL). Copy the url and configure this under your other system.

Thanks