# Epic OP-8195 - Link work packages with files and folders in OneDrive/SharePoint

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-8195

## Detailed specification

### Motivation and background information

### Acceptance criteria

### Out of scope

| Attribute | Value |
| --- | --- |
| Mockups |  |

## Planning

| Attribute | Value |
| --- | --- |
| Roadmap |  |
| Date | 2023-12-04 |
| Votes | 9 |
| List |  |
| Target versions | 13.1.0 |
| Sprint | 13.1.0 |
| Backlog bucket |  |
| Relevance |  |

## Subitems

| ID | Type | Subject | Status | Assignee | Target versions | Project | Priority | Spent time |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| OP-12920 | Implementation | Create and update storage of type OneDrive/Sharepoint | closed |  | 13.1.0 | OpenProject | Medium |  |
| OP-13808 | Feature | Add Enterprise Banner and checks for OneDrive/SharePoint file storage integration | closed |  | 13.1.0 | OpenProject | Medium |  |
| OP-13826 | Feature | Redirect uri flow | closed |  | 13.1.0 | OpenProject | Medium |  |
| OP-12921 | Implementation | Enable login to microsoft GRAPH API | closed |  | Wish List | OpenProject | Medium |  |
| OP-12922 | Implementation | Get work package file links for a OneDrive storage | closed |  | Wish List | OpenProject | Medium |  |
| OP-12923 | Implementation | Direct download of file from OneDrive storage | closed |  | Wish List | OpenProject | Medium |  |
| OP-12926 | Implementation | Get files of OneDrive/SharePoint storage | closed |  | Wish List | OpenProject | Medium |  |
| OP-12927 | Implementation | Get single file of OneDrive storage | closed |  | Wish List | OpenProject | Medium |  |
| OP-12928 | Implementation | Static open of file from OneDrive storage | closed |  | Wish List | OpenProject | Medium |  |
| OP-12929 | Implementation | Create file link for OneDrive storage | closed |  | Wish List | OpenProject | Medium |  |
| OP-12930 | Implementation | Direct upload of a file to OneDrive storage | closed |  | Wish List | OpenProject | Medium |  |
| OP-12931 | Implementation | Show file links of OneDrive storages | closed |  | Wish List | OpenProject | Medium |  |
| OP-12932 | Implementation | Enable creating file links with file picker for OneDrive storages | closed |  | Wish List | OpenProject | Medium |  |
| OP-12933 | Implementation | Enable upload of files to OneDrive storages with location picker and drop zone | closed |  | Wish List | OpenProject | Medium |  |
| OP-13336 | Implementation | Extend creation of OneDrive storages with selection of root directory | closed |  | Wish List | OpenProject | Medium |  |

## Bugs and other work packages

| ID | Type | Subject | Status | Assignee | Target versions | Module |
| --- | --- | --- | --- | --- | --- | --- |
| OP-13261 | Code maintenance | Refactor the ConnectionManager so simplify dealing with multiple Storage Providers | closed | Marcello Rocha Pereira | 13.1.0 |  |
| OP-12925 | Task | Register OpenProject OAuth2 client for GRAPH API usage | closed |  | 13.1.0 |  |
| OP-12917 | Task | Investigate GRAPH API in regard of checklist | closed |  | 13.1.0 |  |
| OP-12905 | Task | Check list for integration of new file storage types | closed |  | 13.1.0 |  |

## Details

| Attribute | Value |
| --- | --- |
| Module |  |
| Enterprise plan |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Designer |  |
| Developers | OP Dev Titan Team |
| Requested by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| Work |  |

## Description

### Goal

The **File storages** module will be extended by more file storage provider types, specifically with **MS SharePoint** and **OneDrive.** These provider types will be selectable alongside the only, currently available provider type **Nextcloud**.

The file storage configuration on OpenProject site will represent the feature set, we can provide for the selected storage. This is highly dependent on the API each storage type provides.

### Acceptance criteria

*   When an admin user creates a new storage, the storage type **SharePoint/OneDrive** must be selectable.
*   A user must be able to link files and folders on a **SharePoint/OneDrive** storage with a work packages from within OpenProject.
*   A user must be able to upload single files from the local drive to a **SharePoint/OneDrive** file storage from within a work package.
*   A **Sharepoint/OneDrive** file storage represents and is scoped to a single drive within the Microsoft API (also know as "Business Drive" or "Document Library").