0

Inside MS Office word we have the Status property as follow:-

enter image description here

and inside a SharePoint online site collection i added the built-in Status site column inside a document library:-

enter image description here

now when i upload a document the Status will be mapped between the MS office word and SharePoint. For example if a document have status = "Not Started" and i upload the document then the Status inside SharePoint will also be "Not Started" (as shown in the above 2 pictures)... but the issue i am facing is that the Status inside MS Office word will be a free text while inside SharePoint it will be a drop-down, so the status inside MS office word can contain a value not inside the drop-down choices as in the "Not Started" case.. so how i can fix this issue? either by modifying the MS office word property or the SharePoint site column?

Thanks

1

There is nothing we can do. The document properties do not have a column setting in Word client similar to the one in SharePoint library, yet changing the settings in SharePoint will not affect the properties in Word either.

Another thing you should notice, since there is no choice type in the default document properties, the Status column in SharePoint will not be accepted as the same property but adding a another one in Word client.

However, the choice field will not pass values to any side when being edit, it just keeps the SharePoint settings but does nothing. The Choice field in SharePoint will use the value from Text field (original document properties), so will the Quick Part in Word.

enter image description here

4
  • thanks for the reply.. but can you explain your answer in more details ? – John John Nov 17 '20 at 1:11
  • 1
    @SharePointTestDev Which part do you need for details? – Chelsea_MSFT Nov 17 '20 at 1:21
  • the following the Status column in SharePoint will not be accepted as the same property but adding a another one in Word client. However, the choice field will not pass values to any side when being edit, it just keeps the SharePoint settings but does nothing. The Choice field in SharePoint will use the value from Text field (original document properties), so will the Quick Part in Word. – John John Nov 17 '20 at 11:14
  • @SharePointTestDev There is a second Status column after the sync, see the screenshot I provide (not sure if you can see that from your end). That’s the choice column from SharePoint, proofing that SharePoint does not accept the Text field Status as the same column, so it adds another one as “SharePoint Properties”. But if we change the value of the second column, it does not pass to SharePoint. These two products are not corresponding that well, so we cannot really do anything about it. SharePoint reads the value from the Text field anyway. – Chelsea_MSFT Nov 18 '20 at 0:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.