I have users submit a form that triggers a flow to create an item in a SharePoint List. The form includes a question to add the Managers email address. A condition checks if the email address is valid by searching for an active account. If Yes I want it to create the item and email the Manager to confirm it has been added. If the email is incorrect or does not refer to an active account, it should take the No route and send an email to the Form Responders' email to notify them an invalid email was entered. The flow looks like this:
I first tried this with just the first row of the condition set to Account Enabled is equal to true. When the form is submitted with the email of a valid account the value in the output of Search for users is set to true and the flow takes the Yes route and creates the item in SharePoint. However, if there is no valid account the output value is set to [0] and should, in theory, take the No route. Run history still shows the flow run as successful but the condition is "greyed" out and no email is sent to notify the form responder that the email entered is incorrect.
I added an extra row to take the Yes route if the output value did not equal [0] and got the same result. I also tried it with just the value is not equal to [0], and another attempt with the expression empty(body('Search_for_users')) equals false. Everything I have tried gives me the same result: a valid email takes the Yes route and invalid greys out the condition but run history says the flow ran successfully.
I would really appreciate some help with this. Thanks!
