Unable to add a version to office files(newer ie., .docx, .xlsx, .pptx) in Sharepoint Online when custom properties are added

Abdul Saif Babu 61 Reputation points
2021-01-29T03:43:30.623+00:00

We are trying to upload content to MS SharePoint using REST API / Sharepoint client UI, while uploading MS Office documents (.docx, .xslx, .pptx) along with required properties,61630-spissue.png61669-spissue2.png

Receiving an error: " You must fill out all required properties before checking in this document) , uploaded version has blank meta data for required fields. This is not the case for other documents - pdf, doc, xls etc.

Can someone please advise on why SharePoint is treating the documents differently and also provide inputs on resolving this issue.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,961 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Amos Wu-MSFT 4,051 Reputation points
    2021-01-29T06:40:07.88+00:00

    Before checking in the docx file, you need to fill in the value for the required column.
    61735-test77.gif
    Updated:
    You could take a reference to this document:You aren't prompted for required information when you upload a file to a SharePoint Online library using the new experience version


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Abdul Saif Babu 61 Reputation points
    2021-02-01T03:57:36.837+00:00

    Thanks @Amos Wu-MSFT for reply. But I think you didn't get the issue clearly, So below are the steps to reproduce our issue

    1. Upload a docx file in a folder/doc library with custom mandatory properties (in our case - Target Scope, Target control type) and provide values for mandatory properties
    2. Now checkout document and upload a new docx file.
    3. Goto Options and click checkin.

    Expectation: Checkin should be successfull and new file should be uploaded and already provided mandatory properties values should be retained

    But currently the newly checkin file is not retaining the custom mandatory properties values. This is only happening for new versions of MS Supported file types(.docx, .pptx, .xlsx) while it retains all values for old file types(.doc, .ppt, .xls)


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.