OData Filter Query on Person Field

Like (0) Share

Report

Posted on 12 Sep 2022 11:21:23 by Gerard Simpson

2,987 Super User 2025 Season 1

I am having issues trying to query a person field in a SPO list using the following syntax:

LessonOwner/Email eq 'help.me@please.com' (Note: LessonOwner is the internal field name)

The problem is I get the following error when running the flow - I cannot see any issue with the field and I tried deleting and replacing this field with the exact same display/internal name adn still ended up with the same error. If I switch the query to AN Other field, there is no error

Any help would be really appreciated.

All responses (3)

Answers (1)

Gerard Simpson 2,987 Super User 2025 Season 1 on 12 Sep 2022 at 13:55:47

Like (1)

Report

Re: OData Filter Query on Person Field

Brilliant - Thanks @Expiscornovus 👍 - Cant believe I missed that

Worst thing is, I had this working previously in another flow, but when adapting it as part of a new solution, I referred to how the fields were written internally by SPO.. what was I thinking!? 😅
Verified answer

Expiscornovus 31,732 Most Valuable Professional on 12 Sep 2022 at 12:26:12

Like (2)

Report
Re: OData Filter Query on Person Field

Hi @AmDev,

As far as I am aware the Email property still needs to be written with a capital M (yes, pretty quirky gotcha 😁). So LessonOwner/EMail instead of LessonOwner/Email.

Can you try:

LessonOwner/EMail eq 'help.me@please.com'

https://powerusers.microsoft.com/t5/Building-Flows/ODATA-filter-on-Get-Items-returns-error-nested-email-of-a-SP/td-p/1457203
Redders 546 on 12 Sep 2022 at 11:26:31

Like (0)

Report

Re: OData Filter Query on Person Field

.