You’re offline. This is a read only version of the page.
Announcements
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 1
PHOTO 2
PHOTO 3
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.
Share
Report
All responses (
Answers (
12,982
