How to update row when a MS Form has been submitted by user

(0) Share

Report

Posted on by CHNGUYEN

When a user submits a response to a Microsoft Form, I would like to update a separate Excel sheet under the column "Status" to "Complete".

Flow idea: User submits form > Excel sheet searches for matching users email > Updates "Status" column to "complete"

Can anybody advise on how to do this? I created the flow below to start off but I can't seem to get it working. Below are some screenshots of me trying some stuff, I've also used the "get a row" function and was unsuccessful. Would appreciate all the help I can get.

Thanks all!

PHOTO 1PHOTO 2

PHOTO 3

Categories:

Process Advisor

All responses (1)

Answers (0)

David_MA 11,767 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to update row when a MS Form has been submitted by user

I am not sure what you are doing with all of the variables and arrays and manipulation of the responder's e-mail address. You may be overcomplicating things. I assume the e-mail address of the person where you want to update the row is in the spreadsheet. If so, your flow just needs these actions:
I don't know why putting the responder's e-mail in a Compose action is needed, but if you just put the value from the form in the Key Value, the flow will fail. I am pretty sure the Key Value is case sensitive, so make sure you have the e-mail formatted how it is in your Active Directory.