Apply to Each - Condition

[CorcoranK]

Hello,

Would anyone be able to advise on an issue I am having with what I thought would be a simple flow. 

1. I have a MS Form that asks a simple question - please add you email address

2. Within the Flow I then Get Response Details 

3. create item in separate SP List 1

4. Then Get Items from a SP List 2 - that stores the emails

5. Then add Apply to each from the Get Items on the SP List 2 to loop through each item

6. I then run a condition to check if the email address on the form matches the email address stored in the SP List 2

The issue is that if the email matches it returns true a couple of times, but then return false even when the email address does match. I have amended the top count on the get items so that is not an issue. 

Does anyone have any ideas why it always returns false after a couple times? Or a better way on how to compare an email in the form question to email stored in SP List?

Many thanks

[Rhiassuring]

Hi there, 

I'm not sure what you're saying the issue is, I'm trying to understand. Based on your screenshot alone, you are telling it "if the email in list 1 matches the email from the form, then, update the list. If it doesn't match, do nothing."  -- which seems odd to me, I'd think it would be the other way around.

Can you show an example of the error you're seeing where it's coming through as "false after a couple of times"? I don't see any reasons that should happen unless somewhere along the way you're referencing another form and it's truly not there...

[CorcoranK]

Hi,

Sorry, I do not think I made my initial question very clear.

I have a SharePoint list that holds peoples email addresses. When a user completes an online form it asks for their email address and then checks the SharePoint list to see whether that email address matches, if it does go and perform an action.

However, the conditions never returns true even when the email address entered in the form matches the one in the SharePoint list, it always returns false.

The flow is fairly simple:

When a new response is submitted

Get response details

Get items - from SharePoint List

Apply to each , Condition - is SharePoint Email equal to form email address

Is there something I am missing. I assume the get items should loop through each list item and run the condition on each item to check whether it is true or false.

Many thanks