Update a collum in Excel from a Microsoft Form Submitted

ryanc23 

It is possible to update a column in Excel based on the responses submitted through a Microsoft Form, so far I know :). You can achieve this using Microsoft Power Automate (previously known as Microsoft Flow). Here's a high-level overview of the steps involved:

1. Set up a flow in Microsoft Power Automate.
2. Configure the trigger for the flow to be when a new response is submitted in Microsoft Forms.
3. Add an action to get the details of the submitted response.
4. Use an Excel connector action to update the corresponding cell or column in the Excel spreadsheet.

Here are more detailed steps to accomplish this:

1. Open Microsoft Power Automate (flow) in your web browser.
2. Create a new flow and select "Automated - from blank" as the flow's template.
3. Set the trigger by searching for "Microsoft Forms" and selecting the trigger "When a new response is submitted".
4. Connect to your Microsoft Forms account and select the form you want to monitor for responses.
5. Add an action by searching for "Excel" and selecting the action "Update a row".
6. Connect to your Excel account and select the workbook and worksheet where you want to update the column.
7. Configure the "Update a row" action by specifying the cell or column that needs to be updated with the corresponding value from the Microsoft Form response.
8. Save and activate the flow.

Now, whenever a new response is submitted through the Microsoft Form, the flow will trigger, retrieve the response details, and update the specified column or cell in the Excel spreadsheet accordingly.

Please note that the specific steps and options may vary slightly depending on the version of Microsoft Power Automate and Excel you are using, as well as the interface changes over time.