AnsweredAssumed Answered

How to Query for email address using Query List Lookup ?

Question asked by jaapsteenis on Jul 17, 2017
Latest reply on Jul 19, 2017 by callum

Could someone explain me what the standard way is to obtain the Email address of a person mentioned in User/Group column in a different Lookup List - using the Query List option ?

 

The way I am currently following seems to be very long as in the SP2010 it was a matter of a single action.

For example my Query List output gives me a result like this :

 

  [{"TerritoryManager":"test1.user@company.com"}]

 

How can I directly get to the email address ?

I noticed a couple of posts on this forum but they do not ring a bell to me.

 have used below approach, it works, but I am 100% sure it's not the most clever solution.

Who has better ideas :-) ?

 

Email From Lookup Value User Group

 

 

Thanks

Outcomes