Skip to main content
Nintex Community Menu Bar

Retrieve Person details via Office 365 Query List

  • June 2, 2020
  • 0 replies
  • 5 views
  • Translate

Forum|alt.badge.img+5

I need to retrieve a person's email details from a list in a different site (containing masterdata) within my tenant, and use the Office 365 Query List function.  The field being retrieved is the normal 'person/group' field but when I use the O365 Query function all it will retrieve is the Display name as text. 

 

I have tried defining the receiving variable as a collection and a dictionary but both produce the same results - just the Display name text.  The query itself is working, but I need an attribute of the field, not just the default text value.

This is what the CAML text of the query looks like:

<View>
<Query>
<ViewFields>
<FieldRef Name="Employee"/>
</ViewFields>
<Where>
<Eq>
<FieldRef Name="Site Location"/>
<Value Type="Text">Haile</Value>
</Eq>
</Where>
</Query>
<RowLimit>1</RowLimit>
</View>

Is there a way to specify the email details when entering the field name?  Employee.Email comes back with field not found.

 

Thanks.

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings