Another Get Items OData Filter Question

[Anonymous]

I have a list that contains a column for email addresses (single line of text). The user wants to store 1 or many email addressed separated by a comma (user1@domain.com,user2@domain.com) in this column. Upon firing the Flow, I am to retrieve an item's data based on the email address (or addresses separated by a column) being passed matching value(s) in the email column.

Pretty straight forward to do this for one email address.  Filter Query: EmailAddress eq strVarEmailAddres

I have no idea when there will be one email address in the column or more that one separated by a column. I realize I need to dynamically create the Filter string. Not sure of the best way.  I feel like I am taking "3 left turns in order to make a right turn".

What is the best way to go about searching for two possible values in one column using an "OR"?

If there are two values in the EmailAddress column I can use split(). Am I on the correct path for this?

Filter Query: OR(substring(EmailAddress, split(strVarEmailAddress,',')[0]), substring(EmailAddress, split(strVarEmailAddress,',')[1]))

Bob

[annajhaveri]

@Anonymous  you need to provide the Filter Query as follows

substringof('string', Column)

Replace string with the email address

Replace Column your column name 'EmailAddress'

[Anonymous]

using substringof produces an error:

"The function operator 'substringof' is not supported or its usage is invalid."

[annajhaveri]

@Anonymous  please share screenshot of your Get Items action,  i would like to review how you have used the substringof filter query.

[Anonymous]

Screenshot attached.

[annajhaveri · Accepted solution]

@Anonymous  the variable is used as text in filter query, you need to select the variable from dynamic content see, below screenshot. Also remove quotes from 'EmailAddress', it should be EmailAddress without quotes, the variable should be within quotes., see below screenshot.

[Anonymous]

Typos left over from trying numerous things. Thank you @annajhaveri! I am getting the results expected now. Just have to clean up the response.