update list item with "edit form response" option in Microsoft Forms

[CROKat]

I recently discovered the option to allow users to edit their MS Form submission after the initial submission. I have a flow set up to create a new item based on the initial form submission. I was wondering if it's possible to take advantage of this edit form submission option and have it update the list item?

I currently have a flow that will update list items (or create new items) based on filter queries, but the edit form submission option in MS Forms seems like a cleaner solution. Has anyone done this?

[v-mengmli-msft · Accepted solution]

Hi @CROKat ,

I assume your flow looks like this:

According to my test, I found that the user's modified response is not updated to the list, in other words, only the new record submitted for the first time is updated to the list. There is currently no relevant action to get the user's modified reply, my suggestion is to add a column to the list to store the Responder's email.

Do not allow users to modify replies, only allow new replies to be submitted, determine whether there is a record of this user in the list before creation, if not, create a record of the current new reply to the table, and if so, find the record submitted by the user before and update.

My testing process for reference:

The expression:

Hope this helps you!

-----------------------------------------------------------------------------------------------------------------------------------

If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,

Rimmon Li

[QuikStudy]

I just had this ask from our research department. It's not the answer I was hoping for, but I suppose it's better than nothing.

[mrocheleau]

What is the syntax you entered in for the Filter Array