{"id":2949,"date":"2018-10-19T13:03:29","date_gmt":"2018-10-19T12:03:29","guid":{"rendered":"https:\/\/www.lieben.nu\/liebensraum\/?p=2949"},"modified":"2018-10-19T13:03:29","modified_gmt":"2018-10-19T12:03:29","slug":"finding-files-in-sharepoint-online-or-teams-that-exceed-218-path-length","status":"publish","type":"post","link":"https:\/\/lieben.nu\/liebensraum\/2018\/10\/finding-files-in-sharepoint-online-or-teams-that-exceed-218-path-length\/","title":{"rendered":"Finding files in Sharepoint Online or Teams that exceed 218 path length"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Update: <a href=\"https:\/\/www.lieben.nu\/liebensraum\/2019\/08\/max-path-length-in-sharepoint-online-onedrive-for-business-and-teams\/\">new version of this script <strong>with GUI<\/strong> here<\/a> \ud83d\ude42<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/10\/files-in-office-365-with-too-long-path-length-excel-error-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1417\" height=\"138\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/10\/files-in-office-365-with-too-long-path-length-excel-error-1.png\" alt=\"\" class=\"wp-image-2951\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/10\/files-in-office-365-with-too-long-path-length-excel-error-1.png 1417w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/10\/files-in-office-365-with-too-long-path-length-excel-error-1-300x29.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/10\/files-in-office-365-with-too-long-path-length-excel-error-1-1024x100.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2018\/10\/files-in-office-365-with-too-long-path-length-excel-error-1-768x75.png 768w\" sizes=\"auto, (max-width: 1417px) 100vw, 1417px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A well known issue when migrating to Office 365 (Sharepoint, Teams and Onedrive) is path length.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Recently, <a href=\"https:\/\/blogs.technet.microsoft.com\/wbaer\/2017\/05\/09\/new-maxpath-limits-in-sharepoint-and-onedrive\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft increased the maximum path length in Sharepoint Online from 256 to 400 characters<\/a> (total length of the URL). This causes issues when you use Office, because <a href=\"https:\/\/excel.uservoice.com\/forums\/304921-excel-for-windows-desktop-application\/suggestions\/10733559-increase-the-218-character-filename-length-limit-t\">Office 2013, 2016 and 2019 do not support paths over 218 characters in length.*<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To help you proactively identify files that exceed this limit I wrote a PowerShell script you can run:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>it can filter based on file type<\/li><li>automatically finds and processes all sharepoint sites in your tenant<\/li><li>automatically finds and processes all team sites in your tenant<\/li><li>it can handle multi-factor authentication<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/gitlab.com\/Lieben\/assortedFunctions\/blob\/master\/get-filesWithLongPathsInOffice365.ps1\">Find get-filesWithLongPathsInOffice365.ps1 on GitLab<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It leans heavily on the great work done by the community around OfficePnP, all credits to the community for providing so much quality code for free!<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">*longer paths may still work, this is not a hard limit<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Update: new version of this script with GUI here \ud83d\ude42 A well known issue when migrating to Office 365 (Sharepoint, Teams and Onedrive) is path length. Recently, Microsoft increased the maximum path length in Sharepoint Online from 256 to 400 characters (total length of the URL). This causes issues when you use Office, because Office &hellip; <a href=\"https:\/\/lieben.nu\/liebensraum\/2018\/10\/finding-files-in-sharepoint-online-or-teams-that-exceed-218-path-length\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Finding files in Sharepoint Online or Teams that exceed 218 path length<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[4,32,39,44],"tags":[],"class_list":["post-2949","post","type-post","status-publish","format-standard","hentry","category-automation","category-office-365","category-powershell","category-sharepoint-online"],"_links":{"self":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/2949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/comments?post=2949"}],"version-history":[{"count":0,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/2949\/revisions"}],"wp:attachment":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/media?parent=2949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/categories?post=2949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/tags?post=2949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}