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 :
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 :
Can anyone please help me to archive this in Power Automate Desktop ?!
Thanks in advance 🙂
Solved! Go to Solution.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.