question

GarethTerblanche-9138 avatar image
0 Votes"
GarethTerblanche-9138 asked YiLu-MSFT answered

Odata syntax for for Get Items from a list where the column is a Person or Group

I am trying to filter the results of a Get Items (from a list) by a persons email address in a column with property of Person or Group. I have tried the following but with no success:

UserName_O365/Email eq 'Email@address.com'
UserName_O365.Email eq 'Email@address.com'
contains(UserName_O365,'Email@address.com')

I can think of a couple of work arounds for this but was wondering it is possible to filter on this column using Odata.

office-sharepoint-onlineazure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered

Hi @GarethTerblanche-9138
Please try this:

 UserName_O365/EMail eq 'Email@address.com'

just replace “m” with “M”.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.