Forum Discussion

raveesh's avatar
raveesh
Frequent Visitor
6 years ago

400 Bad Request Error - Sharpoint Folder

I am receiving a 400 bad request error when I try to get the metadata of the sharepoint folders since once of the file and folder had a single quote in their names. I tried using Table.Replacevalue function on folder column (unexpanded table) but it didn't work. Could you please help me with this issue.

 

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (The expression "Web/GetFolderByServerRelativePath(decodedurl='/aaa/xxxxxxxx/yyyy/zzzzz/T'est Folder')/Files" is not valid.)

 

Thank you,
Rav

Need Help

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi raveesh ,

     

    You have a folder whose name is "T'est Folder" in sharepoint, right? I think replacing value will not return the correct expression because the path is different.

    You could edit the name in sharepoint to avoid the problem.

     

    • raveesh's avatar
      raveesh
      Frequent Visitor
      6 years ago

      Thank you. I don't have permission to change the folder/file names in sharepoint. Is there any other way?