Create Bulk "Document Set" and Add Respective Column Properties in SharePoint Using Excel Metadata File

Asif Rehan 0 Reputation points
2024-06-08T00:28:20.3333333+00:00

I need solution for Bulk "Document Set" Creation in SharePoint using Excel Metadata File as:

  1. Creating multiple Document Set in SharePoint Using Metadata Excel file with Key Column to use unique Document Set names.
  2. During Creation of Document Set, Columns metadata/properties should also be updated as in Excel Metadata file. (Files will be uploaded later in respective sets).
  3. Excel Rows will be used for creating Document Sets and Excel Columns will have the values of Document Set properties.
  4. Is it possible to add the multiple attachments for each set from PC along with.
  5. So, I need help in creating Document Sets and updating the metadata values of sets?
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,150 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,783 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenXu-MSFT 17,666 Reputation points Microsoft Vendor
    2024-06-10T01:56:31.6533333+00:00

    Hi @Asif Rehan,

    SharePoint Server allows for the creation of Document Sets. Document Sets can be created manually or programmatically using PowerShell scripts. However, there is no built-in functionality to create Document Sets in bulk using an Excel metadata file. You can look for help from third-party tool vendors. The tools may allow you to create Document Sets in bulk and update the metadata values of sets using an Excel metadata file.

    If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.