OData Filter Query on Person Field

(0) Share

Report

Posted on by Gerard Simpson

2,987 Moderator

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.

Categories:

Building flows

I have the same question (1)

All responses (3)

Answers (1)

Sort by

Redders 546 on at

Like (0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,851 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
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

2 people found this reply helpful.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (1)

Report
Copy link

Link copied!

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!? 😅

Was this reply helpful? Yes No