MS Form response finds list item and updates list

[TunstallD]

Hi, 

I am using a Sharepoint List as a log and to automatically send an MS Form to an email address. When I receive a response, I want the details to be logged in the empty columns of a specific list item. I thought I had achieved this following this flow Update SharePoint List record with MS Form response by @ScottShearer - However, I have went live with the list today and started 30 items - expecting the response from each form to fill the correct row - first reply come through and it filled in every row. now every reply I get fills in every row. I hope some one can help me resolve this if possible. yikes.

[TunstallD]

I should have inserted these as a photo:

[wskinnermctc]

Your filter in "Get Items" needs to have the SharePoint column name and what it is equal to (eq).

So if you had a sharepoint column titled "SPEmail" and you want to filter by that column using the form response "Email", then the filter query would look like SPEmail eq '[Email]'

Can you double check the Get Items filter query and see if that helps your issue.

[TunstallD]

Thank you - the flow has run successfully, but none of the items have updated with the response. 

[wskinnermctc]

How many items returned from the "Get Items" when the flow ran successfully?

[TunstallD]

all of the columns on the list remained unchanged after the response was sent - the status says succeeded, but no changes at all

[wskinnermctc]

On the flow that succeeded, go look at the run history and look at the Apply to Each. It should have something that is like 1 of 10, and a next button to go through the next 2 of 10 and so on.

In the screenshot above my "Apply to Each" is showing 1 of 3. That means there were 3 apply to each loops on the "Get Items"; therefore my "Get Items" returned 3 items.

Does your "Apply to Each" have a number of results? Can you show a screenshot of the result of the successful flow?

[TunstallD]

ah I see! on a previous successful flow (which has filled all columns, not what I wanted) this has returned 18 

since making the change to eq the get items is grey, as though it hasn't happened.

[wskinnermctc]

If you don't have anything in the Apply to Each, that means that the Get Items didn't return anything. The filter query is incorrect, or needs to be changed so that it is getting the items you want. Right now the filter is basically filtering out ALL of the SP List items, so the query returns nothing.

That means that your SharePoint list doesn't contain the email address from the form. OR If you know the email address from the form is in the SP List, then you need to check the formatting and make sure it matches. (Like the form email "Person.Last@Email.com" will not match a SP List email "person.last@email.com" since the capitalized letters from the form email do not match the lower case letters from the SP List email.)

[TunstallD]

thank you - you have just led me to look at the tolower function, which was incorrect, however I noticed that there were two options in the dynamic content for one question asked in the form - in this instance 'Email' was repeated twice - I picked the second option in the dynamic content list and it has run successfully and updated the list! Thank you very much for your assistance. saved me a migraine.