Forum Discussion
Need help with expand - Lookup fields (@pnp/sp/items)
Hi folks, I have two lists (1. Projects, 2. Schedule). Schedule list include a Lookup Field to Projects List. We are trying the (ref. https://pnp.github.io/pnpjs/sp/docs/items/) "Retrieving L...
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!