Trying to use Send an HTTP request to SharePoint and keep getting an error The expression is invalid

[keef10]

I am trying to create a folder on sharepoint so i can store documents/information from Salesforce. I have been attempting this for a few days and cannot understand why i keep getting either bad request or the expression is invalid.

Error is 

"message": "The expression \"web/GetFolderByServerRelativePath(decodedurl=’/sites/corporate-files/Lists/WIPTesting’)/AddSubFolderUsingPath(decodedurl=’')\" is not valid.\r\nclientRequestId: 4d0c8de6-a30f-400b-9956-54a516928376\r\nserviceRequestId: 23d3d39e-1052-0000-631e-051c3832d657",

"status": 400,

"source": "https://mylifedigital.sharepoint.com/sites/corporate-files/_api/web/GetFolderByServerRelativePath(de...')",

"errors": [

"-1",

"Microsoft.SharePoint.Client.InvalidClientQueryException"

]

}

[v-bacao-msft · Accepted solution]

Hi @keef10 ,

First of all, Flow run history shows that you use Dynamic content-Name to appear to be null, so the decodedurl is followed by a null value. Please make sure the Name is not empty.

In addition, the error message shows "Expression is not valid" because your symbol is wrong. I guess you should paste Uri directly from the blog.

The single quotes in Uri inside the blog don't seem to be in English. Please use the following Uri:

_api/web/GetFolderByServerRelativePath(decodedurl='lists/ListName')/AddSubFolderUsingPath(decodedurl='@{triggerBody()?['{Name}']}')

Image reference:

Fun run history:

Please take a try again.

Edit:

In addition, these two actions suggest not to use the same list, otherwise it will cause a loop. Creating a folder is equivalent to creating a new item, which will trigger Flow again.

Best Regards,

[MarkStokes]

You have some dodgy single quotes in there.

Make sure your single quotes are ' and not angled in any way. They are different characters and invalidate your queries.

- Mark

[Brad_Groux]

This is why I always keep notepad open to copy/paste into first before copying text into SharePoint, Flow, etc. Formatting with copy/paste can be a nightmare.