---
title: "Microsoft SharePoint"
slug: "microsoft-sharepoint"
description: "Reliable and secure sync. Learn how to quickly and easily connect your data SharePoint with Dataddo. Automate file delivery with fully managed data pipelines."
updated: 2026-04-22T17:44:45Z
published: 2026-04-22T17:44:45Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft SharePoint

**Microsoft SharePoint** is a web-based collaboration platform that allows organizations to store, organize, share, and manage documents and content securely. It’s commonly used for creating internal websites, managing workflows, and enabling team collaboration across departments.

## Authorize Connection to Microsoft SharePoint

1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select **Microsoft Sharepoint**.
2. Provide your **Tenant ID**.
  - In the Microsoft Entra admin center, go to the **Overview page**. The ID will be in the **Basic Information** section.
  - For more information, see [Microsoft's official documentation](https://learn.microsoft.com/en-us/sharepoint/find-your-office-365-tenant-id).
3. Rename your ***authorizer*** for easier identification and click on **Save**.

## Connect a New SharePoint Destination

1. On the **Destinations** page, click on the [**Create Destination**](https://app.dataddo.com/destinations) button and select the destination from the list.
2. Select your ***authorizer*** from the drop-down menu.
3. Name your ***destination*** and click on **Save**.

          Need to authorize another connection?

          

Click on **Add new Account** in drop-down menu during ***authorizer*** selection and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).

## Create a Flow to Microsoft SharePoint

1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new).
2. Click on **Connect Your Data** to add your ***source(s)***.
3. Click on **Connect Your Data Destination** to add the ***destination***.
4. Choose the [write mode](https://docs.dataddo.com/docs/data-storages#write-modes) and fill in the other required information.
5. Check the **Data Preview** to see if your configuration is correct.
6. **Name** your flow and click on **Create Flow** to finish the setup.

### File Partitioning

File partitioning **splits large datasets into smaller, manageable partitions**, based on criteria like date. This technique enhances data organization, query performance, and management by grouping subsets of data with shared attributes.

During ***flow*** creation, you can:

- Select one of the **predefined file name patterns**.
- Define your own **custom name** to  suit your partitioning needs.

**Example of a custom file name** When creating a custom file name, use variations of the offered file names.

For example, use a **base file** name and add a different **date range** pattern:

```
xyz_{{1d1|Ymd}}
```

Using this file name, Dataddo will create a new file named `xyz` every day, e.g. `xyz_20xx0101`, `xyz_20xx0102` etc.

For more information, see [Dynamic File Naming Patterns](/docs/dynamic-file-naming-patterns).

---

## Trobleshooting

### Invalid resource Error

**ERROR MESSAGE**

```
Authorization of Microsoft SharePoint failed with following reason: access_denied - AADSTS65004:+User+declined+to+consent+to+access+the+app.
```

This error may be caused by one of the following issues:

1. **Missing API Permissions**: Go to your app's registration in the Microsoft Entra ID portal and ensure you have added the correct API permissions for the resource you're connecting to. **Admin Consent** must be granted.
2. **Database View Connection**: This issue is caused by attempting a connection to a **Database View**, which by itself is insufficient. Connect to the underlying physical database instance that hosts that view, not the view layer itself.

## Related Articles

- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)
- [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes)
- [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl)
- [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling)
- [Data Transformations](https://docs.dataddo.com/docs/data-transformations)
- [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)

Authorizers act as credentials for external services (e.g. Facebook or Google). To enable Dataddo to access and retrieve your data, you need to grant access to accounts that possess admin-level permissions or higher within these services.