text: 02-15-2019 01:57 AM - edited 02-15-2019 11:58 AM
  Hi folks,
  I have two lists (1. Projects, 2. Schedule). Schedule list include a Lookup Field to Projects List.
  We are trying the (ref.) "Retrieving Lookup Fields" according to guidance:
  import { sp } from "@pnp/sp"; sp.web.lists.getByTitle("LookupList").items.select("Title", "Lookup/Title", "Lookup/ID").expand("Lookup").get().then((items: any[]) => { console.log(items); });
  After implement this code we get issue/error trying to query underling special fields (Choice or Lookup Fields).
  sp.web.lists.getByTitle("Vessel%20Schedule").items.select("*, Project/Title, Project/Phase").expand("Project").getAll();
  This throw error, it can't read/get the "Phase" choice field value from the underlying Project List.
  Appreciate assistance and guidance. Thanks!
  02-18-2019 04:20 AM
  02-18-2019 04:20 AM
  02-18-2019 04:51 AM
  02-18-2019 04:51 AM
  Hi @Rajashekhar Sheelvant
  Thank you for your feedback. We've tried without the Lookup field and it works fine.
  Is there a workaround, on how do we get the lookup value into our list?
  02-18-2019 05:14 AM
  02-18-2019 05:14 AM
  02-18-2019 05:21 AM
  02-18-2019 05:21 AM
  @Rajashekhar Sheelvant , thank you. We have thought about this as last resort, as we would prefer a more simplified solution without use of Flow, tweak and workload for this type of simple data extract.
  Hope there is other ways, considering performance issues and solution maintenance. Thanks!