SOLVED

SharePoint Workflow URL Encoding %2520

%3CLINGO-SUB%20id%3D%22lingo-sub-151483%22%20slang%3D%22en-US%22%3ESharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151483%22%20slang%3D%22en-US%22%3E%3CP%3EI%20recently%20got%20this%20error%20on%20my%20SharePoint%20online%20environment.%20Whenever%20I%20initiate%20the%20workflow%2C%20it%20bring%20up%20the%20form%20with%20URL%3A%20https%3A%2F%2Fsite%20url%2F_layouts%2F15%2FIniWrkflIP.aspx%3FList%3D%7B...%7D%26amp%3BItemGuid%3D%7B...%7D%26amp%3BTemplateID%3D%7B%7D%26amp%3BSource%3DDocumentURLPath%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20problem%20is%20document%20URL%20path%20is%20encoded%20as%20%252520%20when%20there%20is%20a%20space%20in%20Document%20Library%20name%2C%20for%20example%3A%20%22Share%20Documents%22%20will%20be%20encoded%20as%20%22Share%252520Document%22.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20you%20hit%20Cancel%20button%20on%20the%20form%2C%20it%20does%20not%20bring%20you%20back%20to%20the%20document%20location%20because%20the%20path%20is%20not%20found.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20only%20experience%20this%20problem%20in%20the%20last%202%20weeks%3F%20Any%20thought%3F%20Is%20that%20because%20SP%20Online%20change%20the%20way%20it%20handle%20%25%20and%20%23%3F%20How%20can%20I%20fix%20this%20issue%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-151483%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWorkflow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-267682%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-267682%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%20for%20sharing%20that%20answer%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266876%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266876%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20company%20too%20was%20encountering%20this%20problem%20when%20opening%20Word%20%2F%20Excel%20%2F%20PowerPoint%20files%20from%20SharePoint%20sites%20or%20OneDrive%20using%20the%20%22File%20-%20Open%22%20and%20clicking%20on%20an%20item%20in%20the%20%22Recent%20Documents%22%20list.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EWe%20have%20been%20planning%20to%20roll-out%20Semi-Annual%201803%20build%2016.0.9126.2259%20then%20because%20of%20other%20issues%20moved%20forward%20to%2016.0.9126.2282.%26nbsp%3B%20All%20other%20issues%20aside%20the%20one%20I%20was%20working%20on%20was%20with%20Microsoft%20OneDrive%20files%20where%20the%20filename%20or%20pathname%20contains%20a%20space.%26nbsp%3B%26nbsp%3B%26nbsp%3BThis%20issue%20continued%20to%20exists%20when%20I%20install%20the%20Monthly%20Targeted%20build%20of%2016.0.10730.20102%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20hover%20over%20the%20link%20of%20the%20ONE%20DRIVE%20file%20to%20be%20opened%20it%20shows%20the%20URL%20path%20correctly%20with%20only%20the%20%2520%20in%20place%20of%20the%20space%20in%20the%20https%3A%2F%2F%20path.%3CBR%20%2F%3Ehttps%3A%2F%2F%3CCOMPANYNAME%3E-my.sharepoint.com%2Fpersonal%2F%3CUSERACCOUNT%3E%2FDocuments%2FTest%2520Folder%2FTest%2520Document.docx%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FUSERACCOUNT%3E%3C%2FCOMPANYNAME%3E%3C%2FP%3E%3CP%3E%26nbsp%3BWhen%20you%20right%20click%20on%20the%20file%20and%20choose%20%E2%80%9CCopy%20Path%20to%20Clipboard%E2%80%9D%20-%26nbsp%3Byou%20actually%20get%20a%20WRONG%20URL%3A%20This%20is%20the%20URL%20that%20copied%3A%3C%2FP%3E%3CP%3Ehttps%3A%2F%2F%3CCOMPANYNAME%3E-my.sharepoint.com%2Fpersonal%2F%3CUSERACCOUNT%3E%2FDocuments%2FTest%252520Folder%2FTest%252520Document.docx%3Fweb%3D1%3C%2FUSERACCOUNT%3E%3C%2FCOMPANYNAME%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%20that%20the%20name%20has%20a%20%2520%20which%20is%20a%20space%20in%20the%20path.%26nbsp%3B%20In%20the%20copied%20URL%20it%20has%20%252520.%26nbsp%3B%20%2525%20translates%20to%20ASCII%20HEX%2025%20translates%20to%20DEC%2037%20which%20is%20the%20ASCII%20for%20%E2%80%9C%25%E2%80%9D.%26nbsp%3B%20Thus%20the%20path%20is%20%2520%20but%20not%20really.%26nbsp%3B%20It%20is%20%2525%20representing%20%E2%80%9C%25%E2%80%9D%20followed%20by%2020%20to%20create%20%2520%20%3D%20space%20character.%20If%20I%20remove%20the%2025%20so%20that%20it%20is%20only%20%2520%20then%20the%20link%20works.%26nbsp%3B%20This%20is%20a%20result%20of%20%22Double-Encoding%22.%26nbsp%3B%26nbsp%3B%20BOTTOM%20LINE%3A%20OFFICE%20for%20WORD%20%2F%20EXCEL%20%2F%20POWERPOINT%20is%20creating%20URLs%20that%20contain%20a%20wrong%20character%20and%20the%20URL%20is%20wrong.%26nbsp%3B%26nbsp%3BThis%20is%20not%20information%20provided%20by%20OneDrive%20or%20SharePoint%20it%20is%20a%20URL%20generated%20by%20the%20MS%20Office%20application.%3C%2FP%3E%3CP%3EAfter%20working%20with%20a%20SharePoint%20%2F%20OneDrive%20Microsoft%20support%20person%20this%20was%20escalated%20to%20a%20%22Special%20Team%22%20that%20supports%20Office%20365%20but%20is%20made%20up%20of%20employees%20that%20also%20seem%20to%20have%20ties%20to%20the%20SharePoint%20%2F%20OneDrive%20team%20in%20their%20past.%3CBR%20%2F%3E%3CSPAN%3E_______________________________________________________%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20ANSWER%20IS%3A%3C%2FP%3E%3CP%3EAs%20we%20discussed%2C%20this%20issue%20is%20being%20caused%20by%20the%20use%20of%20the%20RoamingSettingsDisabled%20key%20in%20Office.%3C%2FP%3E%3CP%3E%5BHKEY_CURRENT_USER%5CSoftware%5CPolicies%5CMicrosoft%5COffice%5C16.0%5CCommon%5CRoaming%5D%3CBR%20%2F%3E%22RoamingSettingsDisabled%22%3DDword%3A0x00000001%3C%2FP%3E%3CP%3EThis%20is%20a%20now-unsupported%20key%20in%20Office%20C2R%2C%20and%20the%20behavior%20you're%20experiencing%20is%20a%20result%20of%20a%20product%20bug%20that%20the%20developers%20have%20elected%20not%20to%20fix%20due%20to%20the%20deprecation%20of%20that%20key's%20use.%3C%2FP%3E%3CP%3EThe%20key%20can%20be%20remove%2Fchanged%20to%20%220%22%20via%20GPO%2C%20as%20it's%20part%20of%20the%20Common%20Office%202016%20policies.%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3E_______________________________________________________%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20GPO%20setting%20is%20available%20in%20the%20current%20.ADMX%20file.%26nbsp%3B%20Those%20deploying%20the%20newer%20versions%20of%20the%20%22Semi-Annual%22%20builds%20of%20Office%20365%20are%20just%20seeing%20this%20because%20of%20the%20incorporation%20into%20the%20Semi-Annual%20code.%26nbsp%3B%20Those%20that%20use%20the%20Monthly%20Targeted%20builds%20should%20have%20already%20been%20seeing%20this%20for%20possibly%20up%20to%205%20months.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20this%20helps%20since%20I%20was%20not%20able%20to%20find%20this%20information%20any%20places%20else%20as%20was%20VERY%20lucky%20to%20have%20directed%20to%20the%20right%20support%20team%20within%20Microsoft.%26nbsp%3B%20It%20was%20with-in%20two%20minutes%20of%20saying%20%22HELLO%22%20that%20he%20was%20able%20to%20provide%20the%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-265083%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-265083%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20issue%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Foffice%2Fen-US%2F10c13497-adf6-4de4-86f8-d011c63e9e8f%2Frecent-sharepoint-files-which-was-opened-local-gets-corrupted-url-where-20-is-replaced-to-2520%3Fforum%3DOffice2016ITPro%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Foffice%2Fen-US%2F10c13497-adf6-4de4-86f8-d011c63e9e8f%2Frecent-sharepoint-files-which-was-opened-local-gets-corrupted-url-where-20-is-replaced-to-2520%3Fforum%3DOffice2016ITPro%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20solved%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-263947%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-263947%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20getting%20the%20same%20issue%20with%20Excel%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EWhen%20I%20access%20a%20file%20from%20the%20Recent%20Files%20list%20in%20Excel%20and%20the%20file%20has%20a%20space%20in%20the%20path%2C%20I%20get%20a%20file%20not%20found%20error.%20The%20problem%20is%20the%20URL%20to%20the%20file%20is%20double%20encoded%20e.g.%20%2520%20for%20space%20becomes%20%252520%3C%2FDIV%3E%0A%3CDIV%3EFor%20example%2C%20the%20URL%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftenant.sharepoint.com%2Fsites%2FSubsite%2FDocuments%2FFile%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftenant.sharepoint.com%2Fsites%2FSubsite%2FDocuments%2FFile%3C%2FA%3E%201.xlsx%3C%2FDIV%3E%0A%3CDIV%3Eis%20encoded%20as%20this%20in%20the%20recent%20files%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftenant.sharepoint.com%2Fsites%2FSubsite%2FDocuments%2FFile%2525201.xlsx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftenant.sharepoint.com%2Fsites%2FSubsite%2FDocuments%2FFile%2525201.xlsx%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3EIt%20should%20encode%20as%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftenant.sharepoint.com%2Fsites%2FSubsite%2FDocuments%2FFile%25201.xlsx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftenant.sharepoint.com%2Fsites%2FSubsite%2FDocuments%2FFile%25201.xlsx%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3EI%20suspect%20the%20issue%20is%20PC%20build%20related%20because%20opening%20the%20file%20from%20a%20PC%20not%20joined%20to%20the%20client%20domain%20and%20opening%20the%20same%20file%20from%20their%20SP%20Online%20tenant%20doesn't%20generate%20the%20double%20encoded%20URL%20in%20the%20Excel%20recent%20files%20list.%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3EAny%20ideas%20on%20what%20is%20causing%20this%3F%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-261094%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-261094%22%20slang%3D%22en-US%22%3E%3CP%3EDear%26nbsp%3BJason%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20the%20same%20issue%20when%20I%20try%20to%20open%20Recent%20Documents%20in%20MS%20Office%20(Word%2C%20Excel%2C%20PP%20...)%20which%20are%20located%20on%20our%20Sharepoint%20Online%20instance.%3C%2FP%3E%3CP%3EThe%20following%20version%20of%20Office%20%2F%20Windows%20are%20installed%3A%3C%2FP%3E%3CP%3EExcel%3A%2016.0.9126.2282%20-%2032%20Bit%3C%2FP%3E%3CP%3EWindows%3A%20Version%201709%20-%2016299.666%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWrong%20Path%20in%20Excel%20Recent%20files%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fxxxx.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%252520Documents%2FCommunication%252520and%252520Safety%252520System%252520DTSS2%2F1%252520Quotations%252520and%252520Contracts%2FPrice-Comparison-NEW.xlsx%3Fweb%3D1%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FXXXX.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%252520Documents%2FCommunication%25252...%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20Path%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fxxxx.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%2520Documents%2FCommunication%2520and%2520Safety%2520System%2520DTSS2%2F1%2520Quotations%2520and%2520Contracts%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FXXXX.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%2520Documents%2FCommunication%2520and...%3C%2FA%3E%3CSPAN%3E%2FPrice-Comparison-NEW.xlsx%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20open%26nbsp%3Bfiles%26nbsp%3Bdirectly%20from%20the%20Windows%20Explorer%20(One%20Note%20integration)%2C%20it%20works%20and%20also%20when%20I%20browse%20inside%20Office%20and%20open%20files%20from%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%20Andreas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254206%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254206%22%20slang%3D%22en-US%22%3E%3CP%3EDear%26nbsp%3BJason%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20the%20same%20issue%20when%20I%20try%20to%20open%20Recent%20Documents%20in%20MS%20Office%20(Word%2C%20Excel%2C%20PP%20...)%20which%20are%20located%20on%20our%20Sharepoint%20Online%20instance.%3C%2FP%3E%3CP%3EThe%20following%20version%20of%20Office%20%2F%20Windows%20are%20installed%3A%3C%2FP%3E%3CP%3EExcel%3A%2016.0.9126.2282%20-%2032%20Bit%3C%2FP%3E%3CP%3EWindows%3A%20Version%201709%20-%2016299.666%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWrong%20Path%20in%20Excel%20Recent%20files%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2FXXXX.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%252520Documents%2FCommunication%252520and%252520Safety%252520System%252520DTSS2%2F1%252520Quotations%252520and%252520Contracts%2FPrice-Comparison-NEW.xlsx%3Fweb%3D1%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FXXXX.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%252520Documents%2FCommunication%252520and%252520Safety%252520System%252520DTSS2%2F1%252520Quotations%252520and%252520Contracts%2FPrice-Comparison-NEW.xlsx%3Fweb%3D1%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20Path%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2FXXXX.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%2520Documents%2FCommunication%2520and%2520Safety%2520System%2520DTSS2%2F1%2520Quotations%2520and%2520Contracts%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FXXXX.sharepoint.com%2Fsites%2FITandCommunicationSingapore%2FShared%2520Documents%2FCommunication%2520and%2520Safety%2520System%2520DTSS2%2F1%2520Quotations%2520and%2520Contracts%3C%2FA%3E%3CSPAN%3E%2FPrice-Comparison-NEW.xlsx%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20open%26nbsp%3Bfiles%26nbsp%3Bdirectly%20from%20the%20Windows%20Explorer%20(One%20Note%20integration)%2C%20it%20works%20and%20also%20when%20I%20browse%20inside%20Office%20and%20open%20files%20from%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%20Andreas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153935%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153935%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20it%20is%20working%20now.%20I%20am%20glad%20you%20guys%20fixed%20it.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%2C%20did%20special%20character%20support%20cause%20that%20issue%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153923%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Workflow%20URL%20Encoding%20%252520%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153923%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20test%20the%20scenario%20again%20and%20see%20if%20it%20has%20been%20resolved.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I recently got this error on my SharePoint online environment. Whenever I initiate the workflow, it bring up the form with URL: https://site url/_layouts/15/IniWrkflIP.aspx?List={...}&ItemGuid={...}&TemplateID={}&Source=DocumentURLPath

 

The problem is document URL path is encoded as %2520 when there is a space in Document Library name, for example: "Share Documents" will be encoded as "Share%2520Document". 

 

When you hit Cancel button on the form, it does not bring you back to the document location because the path is not found. 

 

I only experience this problem in the last 2 weeks? Any thought? Is that because SP Online change the way it handle % and #? How can I fix this issue? 

9 Replies
best response confirmed by Khoa Hoang (Occasional Contributor)
Solution

Try test the scenario again and see if it has been resolved.

Yes it is working now. I am glad you guys fixed it. 

 

So, did special character support cause that issue? 

Dear Jason,

 

I got the same issue when I try to open Recent Documents in MS Office (Word, Excel, PP ...) which are located on our Sharepoint Online instance.

The following version of Office / Windows are installed:

Excel: 16.0.9126.2282 - 32 Bit

Windows: Version 1709 - 16299.666

 

Wrong Path in Excel Recent files:

https://XXXX.sharepoint.com/sites/ITandCommunicationSingapore/Shared%2520Documents/Communication%252...

 

Right Path:

https://XXXX.sharepoint.com/sites/ITandCommunicationSingapore/Shared%20Documents/Communication%20and.../Price-Comparison-NEW.xlsx

 

When I open files directly from the Windows Explorer (One Note integration), it works and also when I browse inside Office and open files from there.

 

Any idea??

 

Best regards, Andreas

Dear Jason,

 

I got the same issue when I try to open Recent Documents in MS Office (Word, Excel, PP ...) which are located on our Sharepoint Online instance.

The following version of Office / Windows are installed:

Excel: 16.0.9126.2282 - 32 Bit

Windows: Version 1709 - 16299.666

 

Wrong Path in Excel Recent files:

https://XXXX.sharepoint.com/sites/ITandCommunicationSingapore/Shared%2520Documents/Communication%252...

 

Right Path:

https://XXXX.sharepoint.com/sites/ITandCommunicationSingapore/Shared%20Documents/Communication%20and.../Price-Comparison-NEW.xlsx

 

When I open files directly from the Windows Explorer (One Note integration), it works and also when I browse inside Office and open files from there.

 

Any idea??

 

Best regards, Andreas

I am getting the same issue with Excel

 

When I access a file from the Recent Files list in Excel and the file has a space in the path, I get a file not found error. The problem is the URL to the file is double encoded e.g. %20 for space becomes %2520
 
I suspect the issue is PC build related because opening the file from a PC not joined to the client domain and opening the same file from their SP Online tenant doesn't generate the double encoded URL in the Excel recent files list.
 
Any ideas on what is causing this? 

My company too was encountering this problem when opening Word / Excel / PowerPoint files from SharePoint sites or OneDrive using the "File - Open" and clicking on an item in the "Recent Documents" list. 

We have been planning to roll-out Semi-Annual 1803 build 16.0.9126.2259 then because of other issues moved forward to 16.0.9126.2282.  All other issues aside the one I was working on was with Microsoft OneDrive files where the filename or pathname contains a space.   This issue continued to exists when I install the Monthly Targeted build of 16.0.10730.20102

 

When you hover over the link of the ONE DRIVE file to be opened it shows the URL path correctly with only the %20 in place of the space in the https:// path.
https://<companyname>-my.sharepoint.com/personal/<useraccount>/Documents/Test%20Folder/Test%20Document.docx

 When you right click on the file and choose “Copy Path to Clipboard” - you actually get a WRONG URL: This is the URL that copied:

https://<companyname>-my.sharepoint.com/personal/<useraccount>/Documents/Test%2520Folder/Test%2520Document.docx?web=1

 

Note that the name has a %20 which is a space in the path.  In the copied URL it has %2520.  %25 translates to ASCII HEX 25 translates to DEC 37 which is the ASCII for “%”.  Thus the path is %20 but not really.  It is %25 representing “%” followed by 20 to create %20 = space character. If I remove the 25 so that it is only %20 then the link works.  This is a result of "Double-Encoding".   BOTTOM LINE: OFFICE for WORD / EXCEL / POWERPOINT is creating URLs that contain a wrong character and the URL is wrong.  This is not information provided by OneDrive or SharePoint it is a URL generated by the MS Office application.

After working with a SharePoint / OneDrive Microsoft support person this was escalated to a "Special Team" that supports Office 365 but is made up of employees that also seem to have ties to the SharePoint / OneDrive team in their past.
_______________________________________________________

The ANSWER IS:

As we discussed, this issue is being caused by the use of the RoamingSettingsDisabled key in Office.

[HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\16.0\Common\Roaming]
"RoamingSettingsDisabled"=Dword:0x00000001

This is a now-unsupported key in Office C2R, and the behavior you're experiencing is a result of a product bug that the developers have elected not to fix due to the deprecation of that key's use.

The key can be remove/changed to "0" via GPO, as it's part of the Common Office 2016 policies.

_______________________________________________________

The GPO setting is available in the current .ADMX file.  Those deploying the newer versions of the "Semi-Annual" builds of Office 365 are just seeing this because of the incorporation into the Semi-Annual code.  Those that use the Monthly Targeted builds should have already been seeing this for possibly up to 5 months. 

I hope this helps since I was not able to find this information any places else as was VERY lucky to have directed to the right support team within Microsoft.  It was with-in two minutes of saying "HELLO" that he was able to provide the solution.

Thank you very much for sharing that answer :)

@Jason Ross  what is the solution to this, I cannot interpret the answer from this article. I am having trouble with url https://sharepointsite.domain.com/projectname/Shared%20Documents/Forms/AllItems.aspx

 

it happens after the Fed-auth redirection is seen, after that %2520 is added in place of %20 in the above url. 

 

is browser/ms office/any specific windows setting is responsible for url encoding.?

 

I'll appreciate any help in the matter, thanks in advance.

 

 

Regards

Ajay Deval