I am attempting to Get Items from a SharePoint list where the value of a particular column is equal to the Department of the user who created the item that initiated the Flow. The problem is that many of our departments include a single quote in them (e.g. Men's Guest Services). When the Odata query hits that single quote it throws an error because single quotes need to be escaped with a second single quote. Unfortunately there is currently no way to do string replacement in Flow to the best of my knowledge.
Any ideas on what to do (short of changing all our department names)?
Single quote in OData Query need to present in pairs.
Which means if your string contains one single quote, we need to "double" it.
For example, the string we would like to use under Filter Query with the field Department is:
Men's Guest Services
Then the formula should be:
Department eq 'Men''s Guest Services'
Check the following screenshots:
Thank you for your reponse!
The issue I am running into is that the Department field is a dynamic value. That means that I would need to have a string manipulation procedure in order to insert that extra single quote. Do you know of a string manipulation for dynamic values in Flow?
@BenGrady assuming you got to the bottom of this but if not you should be able to use the replace() function for this.
To replace a single quote in an dynamic OData Query String value where the example field is Department.
I have a similar problem. I have a flow that uses the 'Get Files' action with a filter. purpose is to check if a file already exist in a folder, if it does it should fetch the properties of that file.
Problem is a that i use the dynamic content 'file name with extension' to filter, and if the file name contains a single apostrophe, it will cause the filter to fail, and say that the expression isnät valid.... since i can't go about changing the name of all files that have a single apostrophe in them, is there another workaround for this?
Hi @niclasdahl ,
As mentioned above, try using an expression like this to escape the quotes in the merged filename, instead of a direct merge of the filename:
Hope this helps.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.