How to add single quotes to each string in Power Automate Desktop

[co21]

Hello everyone,

I have an list which is look like this :

And i used Join Text Action to separated and join each string with comma and result is going to be :

570-AAIS,580-ADGX,KM5221WBKB-NOR,570-AAIS,DELL-E2720HS

And now i want to add single quotes to each string, where i can pass to IN operation into my SQL Query.

The result i'm looking for :

'570-AAIS','580-ADGX','KM5221WBKB-NOR','570-AAIS','DELL-E2720HS'

Can anyone please help me to archive this in Power Automate Desktop ?!

Thanks in advance 🙂

[MichaelAnnis]

Put whatever you actually want into an Escape Text action. The variable produced %EscapedText% is the altered version so that when you use it in anything later, PAD undoes it and gives you what you originally wanted. 

[Highboy]

Hmmm I don't get it (I am a bit slow today 😊)
Could you explain how that would translate text from 

a,b,c,d to 'a','b','c','d'

[Henrik_M]

LOOP 0 --> %List.Count-1%

    SET VARIABLE %List[LoopIndex]% TO '%List[LoopIndex]%'

END LOOP

[Highboy · Accepted solution]

You could also do it like this in two lines of code 😁

Gives the result

[co21]

Many thanks for help 🙂