How to link a Word custom property with a SharePoint library metadata field with options in different languages

COSANO, Luis 0 Reputation points
2024-10-01T15:02:37.38+00:00

Hi!

I'm trying to connect a Word document with a SharePoint library using:

  1. Custom properties created with VBA code in the Word document.

Fields in the SharePoint library with the same names as the custom properties created in the Word template.

Currently, when the Word template is uploaded to the SharePoint library, it works properly. So, the SharePoint library automatically loads the information stored in the Word document's custom properties for simple fields like:

Single line of text

Choice

Hyperlinks

However, SharePoint metadata fields with options in different languages don't add any information.

I have noticed, upon downloading the Word template previously uploaded to the SharePoint library, that in a "Choice" field where I had stored only one of the choices (RPBL), the custom property has been updated to show three different pieces of data:

The ID identifier (ID) – in this example: 239

The text you will see in the column, which is the same as the metadata (text) – in this example: RPBL

The GUID identifier (GUID) – in this example: 498989de-0bee-4271-905b-ad2a7808da6

                 **239;#RPBL|****498989de-0bee-4271-905b-ad2a7808da6b**

Even without administrator rights, it's easy to find values 2 (text) and 3 (GUID) in the SharePoint library, but I can't find the first one (ID).

On the internet, I found that with administrator rights, you can export the metadata lists to a CSV file where this information is provided (ID+text+GUID). However, I have tried this with the company administrator who has full rights, and we couldn't find any button to export.

So,

Could someone confirm if it's still possible to export the SharePoint metadata list from the Term Store and how to do it?

If it's possible, will we find the requested information (ID+text+GUID).

If I store these 3 elements, will SharePoint upload the information automatically?

Finally, is there an easier way to tell SharePoint the value of a field in a library with managed metadata in different languages? Please consider that I only want to use VBA in the Word template and SharePoint capabilities, no Power Automate routines or other tools.

Please note that the metadata fields structure includes values(Country) and sub-values(City), that I will only want to indicate the subvale (City) but on the field we will show the value and subvalue, e.g.: Country:City; I think that it can be done with SharePoint library capabilities indicating only the sub-value (City).

Thanks in advance. Best regards,

Luis.

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
842 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,971 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.