Forum Discussion
Modula
Aug 19, 2022Brass Contributor
Using Lookups with additional columns for document quick part labels
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 prope...
ganeshsanap
Aug 19, 2022MVP
Modula 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:
- Create two more columns in document library to store the values of extended/additional lookup columns
- Hide those columns from list form
- Create a power automate flow on list which will run on item creation/update
- Use "Update item" action in flow which will update newly created two columns with the values of extended/additional lookup columns
- Use these new columns in document quick parts to show the values.
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.
Modula
Aug 25, 2022Brass Contributor
I experimented with this however as many people use the library at the same time the automation kept failing, as members would have the documents open at the same time and it wouldn't work.
In the end I just changed the tile of each lookup to represent the alpha code abbreviation. Everyone has to reference it manually if they are unsure now
I don't see much use for the additional table option for SharePoint looks ups other than being able to see it on the main list if you'd like. Quite frustrating, seems half baked.
In the end I just changed the tile of each lookup to represent the alpha code abbreviation. Everyone has to reference it manually if they are unsure now
I don't see much use for the additional table option for SharePoint looks ups other than being able to see it on the main list if you'd like. Quite frustrating, seems half baked.