1. Use the out-of-the-box Server-Based SharePoint Integration<\/a>
2. Link <\/a>individual records with a Microsoft Teams channel and access the Files<\/strong> tab (which is just SharePoint in the background)
If you don\u2019t want to change your current setup of one folder per customer under a general team channel, official documentation falls short.<\/p>\n\n\n\n
Here’s the good news: there is a way to keep your files in the same location and still connect each individual folder to a record in Dataverse. The downside is that you’ll need to manage the creation of new folders yourself.<\/p>\n\n\n\n
\n\n\n\n
Creating the SharePoint Site record<\/h3>\n\n\n\n
The folder shown in the Documents <\/strong>tab on a Dynamics 365 record is controlled by a related sharepointdocumentlocation <\/em>record. This document location must have a relation to another record in the sharepointsite <\/em>table, where the URL to SharePoint is stored.<\/p>\n\n\n\n First, we need to find the SharePoint Site which is connected to Teams, so open the tab in your Teams channel in which the folders you want to connect are and open SharePoint via the command bar. Copy the URL up to and including the team name (NiklasBschConsulting in the screenshot).<\/p>\n\n\n Now, create the sharepointsite <\/em> record in Dynamics 365. I’m using the new settings experience, but it works the same with the old one. Set the Name <\/em>field with a display name and the Absolute URL<\/em> field with the URL you just copied. Check List component is installed<\/em> as well. The next step is creating Document Locations. This step will be different depending on your current Teams SharePoint folder structure. In my demo case, I created the customer folders in the Files tab without any subfolders, so in SharePoint there were two automatically generated folders „Freigegebene Dokumente“ (Shared Folders in english, but this is a german tenant) and then „General“. In „General“ were the three folders „A. Datum Corporation“, „Blue Yonder Airlines“ and „Fourth Coffee“. So in sum, to connect the three accounts to the folders, five Document Locations need to be created.<\/p>\n\n\n\n For every folder you want to connect to a Dynamics record, you\u2019ll need a corresponding Document Location. Don\u2019t forget: you\u2019ll also need to create one for each parent folder. This can be done from the SharePoint Site record under „Related“ – „Document Locations“. Fill in the display name (usually just the folder name) and the Relative URL<\/em> (folder name as well). You also need to choose the right Parent Site or Location<\/em>, which is either going to be the SharePoint Site created earlier or the parent folder document location. For any Document Location you want to show on a record, fill the Regarding <\/em>Lookup just like an activity.<\/p>\n\n\n\n The last step is enabling the „Setting up SharePoint document management“ setting for all tables you want to connect in the table properties and adding the document subgrid to your form.<\/p>\n\n\n Voil\u00e0, users can now access their files from both the familiar Teams interface and within the corresponding Dynamics 365 account. While this solution works for connecting existing folders with records, it doesn\u2019t automate folder and document location creation for new accounts.<\/p>\n\n\n\n If you’d like to streamline this further, there will be another post coming, where I’ll show you how to use Power Automate to automatically create standard folder structures in SharePoint for new accounts! In the meantime, take a look at Linn Zaw Win’s blog post<\/a>, to get an idea of how to approach this.<\/p>\n\n\n\n <\/p>","protected":false},"excerpt":{"rendered":" Imagine this: your team has built an efficient file organization system in Microsoft Teams, where each customer has their own dedicated folder within your general team channel. It\u2019s straightforward and ensures everyone can easily access the files they need.But when it’s time to link these folders to Dynamics 365, you’re faced with a dilemma: none… Read More »Integrating Dynamics 365 with existing Microsoft Teams File Structures<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":480,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"[\"content\",\"tags\",\"comments\"]","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[14,17,16],"tags":[22,21,18,20],"class_list":["post-466","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dataverse","category-integration","category-sharepoint","tag-dynamics-365","tag-integration","tag-sharepoint","tag-teams"],"featured_image_src":"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Playmobil-Cover.png","author_info":{"display_name":"Niklas B\u00f6sch","author_link":"https:\/\/niklas-boesch.de\/en\/author\/niklasboesch"},"_links":{"self":[{"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/posts\/466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/comments?post=466"}],"version-history":[{"count":18,"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/posts\/466\/revisions"}],"predecessor-version":[{"id":507,"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/posts\/466\/revisions\/507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/media\/480"}],"wp:attachment":[{"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/media?parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/categories?post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/niklas-boesch.de\/en\/wp-json\/wp\/v2\/tags?post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/image-1024x756.png\")
<\/figure>\n\n\n\n\n
![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Teams-Open-in-Sharepoint-800x400.png\" "\\"Teams")
<\/li>\n ![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Copy-Sharepoint-URL-800x400.png\" "\\"Copy")
<\/li>\n <\/ul>\n <\/div>\n \n <\/div>\n<\/div>\n\n\n\n
After saving, you need to copy the GUID of the newly created record.
The sharepointsite <\/em>table has a poorly documented choice attribute called Service Type<\/em>, which can not be added to a form but needs to be set to the right value if the record refers to anything but a standard SharePoint Site. In the case of MS Teams Files, it needs to be set to 3 (MS Teams). I’m using the Dataverse REST Builder in XrmToolBox for this, as in the screenshot below.<\/p>\n\n\n\n
![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Create-Sharepoint-Site-800x400.png\" "\\"Create")
<\/li>\n ![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Dataverse-REST-Builder-800x400.png\" "\\"Dataverse")
<\/li>\n <\/ul>\n <\/div>\n \n <\/div>\n<\/div>\n\n\n\n
Creating Document Locations<\/h3>\n\n\n\n![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Document-Location-Setup.png\")
<\/figure>\n\n\n\nNearly done…<\/h3>\n\n\n\n
\n
![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Sharepoint-Table-Setting-800x400.png\" "\\"Sharepoint")
<\/li>\n ![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Account-Form-Maker-Portal-800x400.png\" "\\"Account")
<\/li>\n ![\"\"](\"https:\/\/niklas-boesch.de\/wp-content\/uploads\/2024\/10\/Account-Form-Display-800x400.png\" "\\"Account")
<\/li>\n <\/ul>\n <\/div>\n \n <\/div>\n<\/div>\n\n\n\n