Jun 07 2023 02:06 PM
Jun 07 2023 02:06 PM
I'm wondering if this can be done please and if so, how?
I have a list of people that contains their name, number, email etc..
I then message them asking them to fill out a Microsoft Form to book an appointment with me.
Instead of filtering through the form and spreadsheet manually, I want the form to be able to maybe put an X or something next to a persons name in my spreadsheet to say that they've booked/filled out the form or even input the date they have selected so then I know who to chase up if they haven't booked.
So I want excel to cross match the form responses and update each individual automatically.
I've tried looking on flows/automations but not a clue where to start!
Is this possible? If so can someone explain how please?
Jun 07 2023 11:27 PM
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:
Here are more detailed steps to accomplish this:
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.
Jun 12 2023 11:26 AM
Jun 12 2023 12:00 PM
On the flow first is "Get response details" step. It returns Response Id for the triggered answer. Returned value for the filed will be like outputs('Get_Response_details)?['body/field_name'] which could be inserted from dynamic contents on next step.
If with above response you'd like to add new row in some table in other Excel file, step will "Add a row into table" where you map fields in this table on the values received on previous step. For the each field that could be inserted value from dynamic content or some expression based on it.
If you'd like to update some row in that table, when you need to have Key column and key values within it. Steps will be Get Row and Update Row.
Above assumes form wasn't created from Excel Online and you don't receive responses into that file automatically.