Back to blog

5 Most Important Building Blocks for Document Management in Dynamics 365

Before you switch on Dynamics 365 Document Management, evaluate the five building blocks that decide whether your SharePoint integration scales. A field guide to filing structure, permissions, metadata, search and platform limits.

Sep 14, 2023 7 min read

What Does Document Management Mean in Dynamics 365?

Dynamics 365 attachments represent the only native storage method within the platform. However, these fall short of professional document management standards. To address this limitation, Dynamics 365 offers a Document Management feature that enables storing documents in SharePoint instead—a platform specifically designed for document storage.

Why Address This Topic?

While Dynamics 365 provides a standard document management feature, simply activating it without proper planning can lead to costly migration projects later. A dedicated Dynamics 365 SharePoint integration avoids that. Five critical aspects require evaluation before implementation to avoid environmental disorganization.

Basic Principles of Dynamics 365 and SharePoint Integration

The foundation involves creating a workspace in SharePoint for each Dynamics 365 record. Your environment contains entities (Account, Quote, Contact, Lead, Opportunity) that represent basic structures for records.

Integration Goals

  • Creating document locations for records and organizing them by entity type
  • Transferring Dynamics 365 permissions to SharePoint authorization structures
  • Syncing metadata from records to stored documents
  • Enabling enhanced search functionality in SharePoint

Terminology

TermPlatformDefinition
EntityDynamics 365Business data models used to track sales, marketing, and service activities
DatasetDynamics 365A single record created within an entity (equivalent to a database row)
MetadataDynamics 365Definitions for entities, attributes, and relationships between entities
WorkspaceSharePoint OnlineStorage location representation where documents are kept; can be folders, Document Sets, Site Collections, or Teams groups
MetadataSharePoint OnlineColumns in lists/libraries for grouping, categorizing, and tracking information

What Does Dynamics 365 and SharePoint Integration Look Like?

Dynamics 365 with SharePoint DMS: 8-step document flow between Dynamics 365 records and SharePoint
The 8 steps: how a Dynamics 365 record's documents end up filed, secured and metadata-tagged in SharePoint.

The integration process follows these steps:

  1. A record is created in Dynamics 365
  2. A document location or workspace is created for that record in SharePoint
  3. Permissions and metadata synchronize to the SharePoint workspace
  4. A document is uploaded to the Dynamics 365 record
  5. The document stores in SharePoint in the background
  6. Record metadata transfers to the document
  7. Access restrictions mirror Dynamics 365 permissions
  8. The uploaded document displays under the record in Dynamics 365

5 Key Building Blocks of Dynamics 365 and SharePoint Integration

Valprovia Integrator: connecting Dynamics 365 with Microsoft Teams and SharePoint
Valprovia Integrator bridges Dynamics 365 records with SharePoint and Microsoft Teams workspaces.

1. Filing Structures

Storage structures fundamentally determine the entire integration concept. Scalability considerations are critical, along with decisions regarding flat versus hierarchical organization. Greater hierarchy increases complexity and error potential.

2. Permissions

Authorization requirements often emerge after initial planning phases. The security concept may necessitate revisiting storage structure decisions. Dynamics 365 supports three authorization levels:

  • Business Unit
  • Team
  • Access Team

These must map appropriately to SharePoint structures while maintaining simplicity to prevent system errors.

3. Metadata

Each entity requires definitions of which attributes transfer to stored documents. Balance proves essential—insufficient metadata reduces user acceptance since document content becomes invisible, while excessive metadata increases error risk.

4. Search

Define which user groups will access documents, designate responsible parties, and establish access types to deliver customized search results. This capability significantly boosts employee productivity for those accessing Dynamics 365 documents.

5. Limitations

System limitations require careful attention. Both Dynamics 365 and SharePoint Online have constraints needing different handling approaches. Expert consultation proves essential to prevent unexpected costs during later stages.

How Standard Document Management Handles Key Building Blocks

The default Dynamics 365 Document Management feature cannot effectively address:

  • Custom storage structures
  • Metadata synchronization
  • Permission synchronization
  • Scalability
  • Filtering documents by specific criteria (e.g., documents belonging to particular accounts)

Alternative Solutions

Third-party integration solutions exist that account for all five building blocks. These mature solutions shorten project timelines and reduce individual implementation efforts compared to building custom solutions.

Conclusion

This article provides criteria for evaluating Dynamics 365 and SharePoint integration. Based on specific requirements, organizations can evaluate each building block and design suitable architecture for their needs.

Frequently asked questions about document management in Dynamics 365

  • What are the 5 building blocks of Dynamics 365 and SharePoint integration?

    Before a Dynamics 365 and SharePoint integration project, five aspects must be evaluated: filing structures, permissions, metadata, search, and limitations. Filing structures fundamentally determine the entire integration concept, permission requirements may force you to revisit those structures, each entity needs defined metadata, search boosts productivity, and both platforms have system limitations that require careful attention.

  • Why store Dynamics 365 documents in SharePoint?

    Dynamics 365 attachments are the only native storage method within the platform, but they fall short of professional document management standards. SharePoint is specifically designed for document storage. That is why Dynamics 365 offers a Document Management feature that lets you store your Dynamics 365 documents in SharePoint instead and benefit from its strengths.

  • Which building blocks does the standard Dynamics 365 Document Management feature not cover?

    The default feature cannot effectively address custom storage structures, metadata synchronization, permission synchronization, scalability, and filtering documents by specific criteria (for example, finding all documents belonging to a particular account). These require additional configuration, custom development, or a third-party solution.

  • What is a workspace in Dynamics 365 and SharePoint integration?

    A workspace is the representation of a storage location in SharePoint where Dynamics 365 documents are kept. The foundation of the integration is creating such a workspace for each Dynamics 365 record. A workspace can take one of four forms: folders, Document Sets, Site Collections, or Microsoft Teams groups.

See Valprovia live
in 30 minutes

Your use cases, one demo, one pricing proposal. No sales pressure - directly from the Valprovia team.