Answered

OData/Filtering Help

(2) Share

Report

Posted on by JL-21120807-0

Hi all

I have a SharePoint List "Client", with 2 fields in it: Company Code and Email ID. Email ID can contain one or more contact persons email addresses, seperated by ";"

ComplanyCode Email ID

CPY001 bob@gmail.com

CPY002 Tom@outlook.com;Lisa@gmail.com;Ann@mito.com

CPY003 Robert@intnet.mu

After I received a mail, I am storing the Email id of the sender in a variable SenderEmailID.

I want to filter the List using Get Items in PowerAutomate to retrieve the CompanyCode where the SenderEmailID matches Email ID.

How can I achieve it? Using OData?

Seeking your assistance. Thanks.

Jaweed

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

stampcoin 5,146 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

JL-21120807-0 Hi,

You can use Odata query, like use substringof function. ( I typed substring, sorry)

or you can use filter array.

Was this reply helpful? Yes No
stampcoin 5,146 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

JL-21120807-0

no substring of.... in the fx.. below I used filter array.

first , i limited the result

Was this reply helpful? Yes No
w.p 8,345 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

fyi PowerAutomate and SharePoint OData filter queries
https://blog.velingeorgiev.com/powerautomate-and-sharepoint-odata-filter-queries

Was this reply helpful? Yes No
JL-21120807-0 73 on at

Like (1)

Report
Copy link

Link copied!

@stampcoin Thank you. I used substringof, working properly.

I do not know the steps to implement the Filter Array option, I would have liked to know how implement, for knowledge building.

Thank once more.

Jaweed

Was this reply helpful? Yes No
stampcoin 5,146 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@JL-21120807-0, Hi.

Use Filter array, will be like this.

if you don't want to use for each. you can use Odata query in step 3, for example, you have a field which can identify the mail from which company, if it is unique, you may not need other steps.

please let me know if the screenshot make sense to you.

Was this reply helpful? Yes No