Match email submitted in a form to person email in sharepoint

[Murderbot]

I'm trying to match an email submitted in a form to a person email using a condition, but the flow doesn't find the email address in the Sharepoint list.  The flow 'successfully completes', it just doesn't check the Sharepoint item I want it to. 

1. The flow is triggered by a form response

2.  I then pull all records from my SP list. 

3. Apply to Each 2 is based on the Tech Assets list. (the compose and array commmands are not applicable)

4. The condition runs through the Current User field (a person field) to compare the user email to the email entered in the MS form.  If true, it changes the list item containing that person email, if false it sends me an email with the Sharepoint entry and the form entry (for testing).

The odd thing is that I get emails for all the test entries except for the one that matches and the flow does not catch the matching entry.  I thought perhaps it was capitalization or format (form is string, user email is not(?)) but neither test changed the outcome.  I've also made sure that the fields are pointing back to the right list.

The flow segment in question

Thanks for any assistance!

[v-yamao-msft]

Hi @Murderbot ,

Do you want to check if the email submitted in a form matches the person email in SharePoint?

I have made a flow likes below for your scenario, please check it for a reference.

In the flow, I initialize a string variable, then create a collection for existing email addresses in the list.

Use the first Condition to check if the variables contain the submitted email.

If yes, add Condition 2 to figure out the specific item.

If no, send an email.

Images for your reference.

Please take a try with it on your side and feel free post back if you need more help.

Best regards,

Mabel

[Murderbot]

Thank you for the reply.  Your solution causes the Flow to complete successfully but does not solve the data problem.  In testing your solution I found that when the data is pulled from the SP list, it is not including all the rows.  I tried removing and readding the 'Get Items' function and it did not fix the issue.  There are no filters on the function - I'm not sure why it's not returning all the data.