Aug 18 2022 10:29 PM - edited Aug 18 2022 10:30 PM
When you setup lookup columns inside SharePoint you can choose to show additional source columns from the lookup list.
However when you setup a word document and load the quick part document property labels, it only shows the first column associated with the look up, despite the library the file is in showing all columns.
Is there anyway around this yet without changing the identifying column of the lookup?
I want to make a unique code at the document footer that goes something like, APL-IFT-PCD
Which comes from 3 lists, company, department document.
Each list has an abbreviation alpha 3 code.
I.e company Apple is APL.
Even though the document library shows both columns using the show additional columns from the lookup list, inside the word document quick parts it only shows the first column Apple which defeats the purpose.
Thankyou
Aug 19 2022 04:03 AM
@silaman This is the default behavior of SharePoint while using lookups in document quick parts. It can only show the main lookup column value or lookup list item ID.
I am not sure if there is any out of the box way to get those properties in document using quick parts.
If it not, here's workaround you can try:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Aug 24 2022 11:24 PM