I have a very simple flow which triggers upon receiving an email. In the next steps the details of the mail will be extracted and the email of the sender will be stored in a variable called mailUser.
In the next step I want to check if the email of the sender is already stored in one of my Sharepoint Lists. In order to do so, the flow will get all of the data from the sharepoint list and will store the desired column “email” in a variable array named userArray.
Both variables seem to work and provide me with the data shown below:
mailUser
[email protected]
userArray
[
{
"Email": "[email protected]"
},
{
"Email": "[email protected]"
},
{
"Email": "[email protected]"
},
{
"Email": "[email protected]"
}
]
The sharepoint list only contains the test email (4x)
Condition
In order to comparee the two values, I added a condition with the “contains” expression. However, it always seems to result FALSE.