Escape Single quote from string

(2) Share

Report

Posted on by vaishali_37

Hi All,

I am creating folders in SharePoint using ms flows.

it works perfectly when "Output" does not have "single quote" in that. when there is single quote let say Output value is "CustomName'Test" it fails because of quote.

how can I escape that single quote. I don't want to replace that single quote with blank or any other value.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

fchopo 8,003 Moderator on at

Like (3)

Report

Hello @vaishalivyas1
Please, have a look at this post by @PieterVeenstra on handling apostrophes and single quotes in Flow: https://sharepains.com/2019/10/07/handling-apostrophes-in-microsoft-flow/
Basically, you should insert a "\" character before the quote character, with the following expression: replace(outputs(),””,’\”’)
Hope it helps!
Ferran

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (3)

Report

Hi @vaishalivyas1

You can also try this method: Intialize a variable with quote and enter value as a single quote and then use the expression below:

Expression:

replace(triggerBody()['text'],variables('quote'),'')

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
lliu_western 289 on at

Like (0)

Report

@yashag2255

this whole image is the return value I got:
by using this formula:
But I only need the highlighted text, how can I get the substring top at the first single quote it encounters?

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Hello @lliu_western

You could use the split function and getting the first element:

first(split(your_expression,''''))

Hope it helps!

Ferran

Was this reply helpful? Yes No
zylantha 6 on at

Like (2)

Report

This is an incomplete solution to the issue.

You should use encodeUriComponent() instead, which will encode all invalid characters - not just single quotes.

Was this reply helpful? Yes No
smarydas 9 on at

Like (0)

Report

Thanks @zylantha ... It works...

Was this reply helpful? Yes No