Forum Discussion
How to handle single quotes in the filter property with Get Items actions
If you are using the SharePoint Get Items actions and using the Odata Filter Query syntax, then you need to handle single quotes in your filter syntax. Since a single quote is a special characte...
IvanWilson So if I want to replace an apostrophe with a single quote would it be???
'FileLeafRef eq 'replace(variables('FileName'),''`','''')'
Kevin2000 You can use this filter:
FileLeafRef eq 'replace(variables('FileName'),'`','''')'
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap To convert the later part to expression automatically, try:
FileLeafRef eq '@{replace(variables('FileName'),'`','''')}'Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Logged in, looked at ellipsis and all over but do not see any place to mark "Mark as Best Response", but above was the best response and it worked.
