Forum Discussion
Update a collum in Excel from a Microsoft Form Submitted
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 t...
Hello! I've just run a test flow and keep getting an error message come back...
So I've selected the location, document library, file, table, key collum and in the key value it has Response id.
How does it search for example an email address on the form which matches an input in my spreadsheet with that same email address to then put an X or something in that specified row?
So I've selected the location, document library, file, table, key collum and in the key value it has Response id.
How does it search for example an email address on the form which matches an input in my spreadsheet with that same email address to then put an X or something in that specified row?
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.
