Business Central and OneDrive

Business Central and OneDrive

Lately I was searching in the BC19 preview container and when I want to change the company I have noticed a new option in the 'My Settings' menu:

Geen alternatieve tekst opgegeven voor deze afbeelding









It is called the "Cloud Storage" option. When you click on the hyperlink Business Central is looking for the user his OneDrive. But were is this used?

In codeunit 9510 "Document Service Management" there are two new functions: OpenInOneDrive and OpenInOneDriveFromMedia. If you do a were used on those two function you see it is used in the "Report Inbox" page and the attachment page.

Geen alternatieve tekst opgegeven voor deze afbeelding

In the attachment page there are two new options added in BC19. "Open in OneDrive" and Download. If you click on "Open in OneDrive" the file is automatically copied to your OneDrive and openend. For example if it is a Word file then Word Online will be opened.

The download option will download the file as an hyperlink to your client.

Also in the "Report Inbox" the two options are there:

Geen alternatieve tekst opgegeven voor deze afbeelding

If the file is already there in your OneDrive you get the message:

Geen alternatieve tekst opgegeven voor deze afbeelding

So everything is also copied there and not removed!

But when you open an PDF file the preview is there:

Geen alternatieve tekst opgegeven voor deze afbeelding

Another create feature. But hope this is just the start of the new integration. On Yammer there is also a message that the following features will come:

  • Developers will be able to implement a third action, Share, that displays the standard Microsoft 365 file sharing window, directly within Business Central. The Share window allows users to share a link with others, email a link, or attach a copy of the file to an email.
  • Improvements to the end-user sign-in experience when using OneDrive from Business Central, reducing the number of windows required to handle identity and consent.
  • Variations to the AL methods will be made available that give more granular control over where and how the file is copied to OneDrive before it is opened or shared.

Note: I'm not a fan for putting files in your database! (This because the attachment functionality is stored in the media table). Your database is getting big. But I think the database is for storing data and not files. There are better solution such as SharePoint Online, Azure File Storage or Azure Blob Storage.


Michael Glashouwer

Business Central / NAV Developer ? Power Platform ? Azure

3 年

Wij gebruiken MS Flow integratie tussen bc en sharepoint....werkt perfect

Elise Avignon

Projectmanager bij 4PS

3 年

Simon Stegeman hier wordt ik blij van! Jij ook?

Kennie Nybo Pontoppidan

Principal Program Manager at Microsoft. I help ERP customers in the SMB space run their business.

3 年

In BC 2021w2, we also added a system module for BYO Azure Storage. This means that you can save files to storage in your extensions instead of using the database.

Peter Korpershoek

Owner / ERP voor Food en AGF / Dynamics Business Central

3 年

Jan-Willem Dooms / Erwin van Wezel database groei neemt wel toe nogsteeds.

要查看或添加评论,请登录

社区洞察

其他会员也浏览了