I have a flow that sends users an email once they submit a request. I identified two conditions based on which this email should go out. However, the flow sends the email any time I edit the item in the SharePoint list and NOT only when the conditions are met. Here is my flow:
1. When an item is created or modified (in Sharepoint) ->
2. Get item (Sharepoint) ->
Here I show the item ID and info about the site and list
3. Compose ->
This is the first compose in which I select "Status value" which is the value I need for my first condition
4. Compose 2 ->
This is my second compose in which I select "Project Lead" which is the second item I need for my second condition
5. Condition ->
Output (from the first compose) is EQUAL to "Not Started" (status value)
Output 2 (from the second compose) is NOT EQUAL to NULL
6. Switch ->
If yes send an email; if no terminate What could be missing?
The flow sends emails even when the status is other than Not Started. Thank you in advance!!
