Forum Discussion
Need help with expand - Lookup fields (@pnp/sp/items)
Hi gselvag ,
pnpjs is a wrapper js utility for sharepoint REST API and it is not possible to fetch choice field using lookup functionality of REST API. Can you try excluding the choice field and check if your query works.
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?
gselvag , You may probably store this value in a hidden field. Please do not use calculated column for this but you can use designer workflow or MS flow. and you can try fetching this hidden field using same logic. Not sure how it fits your requirement, but this is one of the option.
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!
