title: Expanding fields not working fully on SharePoint Lists
body: <p>I am following the documentation for <a href="https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/list_get" rel="nofollow noreferrer">Get metadata for a list</a>. </p>
  
  <p>Querying using either PowerShell or the Graph Explorer fails to fully expand the fields for items in a SharePoint list.</p>
  
  <p>An example of this is a lookup field called <code>Responsible</code> that looks up users in Azure Active Directory (or in SharePoint terms, the column is a <code>Person or Group</code> column, limited to people only). </p>
  
  <p>Once selected via the GUI, it's populated with a display name (although I'd hope for more definitive information to be stored on the back end, like <code>UPN</code>). </p>
  
  <p>When querying the Graph API using the form:</p>
  
  <pre class="lang-ps prettyprint-override"><code>$Uri = "https://graph.microsoft.com/v1.0/sites/$($SPSite.id)/lists/$($ServiceList.id)/items?expand=fields"
  $Data = Invoke-RestMethod -Headers @{Authorization = "Bearer $accesstoken"} -Uri $Uri -Method Get -ErrorAction Stop
  </code></pre>
  
  <p>we get something like this:</p>
  
  <pre class="lang-ps prettyprint-override"><code>@odata.etag               : "REMOVED"
  Title                     : Storage Platform
  Description               : Central storage platform
  ResponsibleLookupId       : 14
  Responsible2LookupId      : 13
  AccountableLookupId       : 3
  Features                  : NFS
  AudienceLookupId          : 92
  RequestProcess            : {@{LookupId=1; LookupValue=Service Desk}}
  Support                   : {@{LookupId=1; LookupValue=Service Desk}}
  AvailabilityLookupId      : 1
  DependsOn                 : {}
  O365GroupLookupId         : 87
  LifecycleStageLookupId    : 2
  ConsultLookupId           : 88
  id                        : 1
  ContentType               : Item
  Modified                  : 2017-11-17T10:47:07Z
  Created                   : 2017-11-17T10:47:07Z
  _UIVersionString          : 1.0
  Attachments               : False
  Edit                      : 
  LinkTitleNoMenu           : Storage Platform
  LinkTitle                 : Storage Platform
  ItemChildCount            : 0
  FolderChildCount          : 0
  _ComplianceFlags          : 
  _ComplianceTag            : 
  _ComplianceTagWrittenTime : 
  _ComplianceTagUserId      : 
  </code></pre>
  
  <p>You can see that the field <code>ResponsibleLookupId</code> just gives a value of <code>14</code> which is not useful. Other fields link to Office 365 Groups, but again return values. As such it's impossible to link any of this data to users/groups and is very limited in value except when looking at it through the portal.</p>
  
  <p>How do we expand this data? Will it be provided by the API call at a later date, or do we have to perform further look ups?</p>