String Functions in Power Automate Desktop | Get Subtext | Crop | Trim | Replace | Reverse | Split

Do you want to extract a part of a string in Power Automate Desktop? Or simply replace a certain character or word? Remove whitespaces or split a string into a list? Yep.. Then you're going to need string activities! In this tutorial I explain some of the most popular string activities in Power Automate.
⭐️ Skip through the video ⭐
00:00:00 - Intro
00:00:15 - The Get Subtext activity (to extract a text based on character occurence)
00:02:28 - The Crop text activity (to extract text based on text before and after the substring)
00:04:53 - The Trim activity (to remove whitespaces at the start or end of a string)
00:06:08 - Replace Text (to replace a part of a string)
00:07:34 - Reverse Text (to reverse a text)
00:08:08 - Split Text (to split a text based on a delimiter and convert to a list)
⭐️ Related videos ⭐
✔️ Dates in Power Automate Desktop: • Power Automate Desktop...
⭐️ Follow me ⭐
💼 LinkedIn: / thomas--janssen
🧡 Instagram: TomsTechAcademy
#powerautomate #powerautomatedesktop #roboticprocessautomation

[@williammah1605]

very useful.

[@TomsTechAcademy]

Thank you for your comment 🙏 glad my video is helpful for you

[@pirahdahri3320]

what if I want to display some percentage as a string like 'you got 80%'. How to get that?

[@mindvoice4u]

Can we do crop text in excel and paste in same column

[@TomsTechAcademy]

Yes, sure you can! Just save the content of the cell in a variable, crop text and paste the result of the crop text back in excel with a write to excel worksheet activity

[@mindvoice4u]

In desktop automate , one email have multiple data to crop. I am able to successfully crop (using flag between two text) only first set of data. I not able to crop the next ...set of text data in that same email. How to do that?

[@steve_aventura]

How do I replace line breaks

[@TomsTechAcademy]

Hi, you can use a "Replace Text" activity.
Text to parse: the original text
Text to find:

Use regex to find and replace: turn this toggle on
Replace with: text you want to replace the line breaks
Good luck!

[@smanzoli]

@@TomsTechAcademyalmost correct.
/n will not work, but /s/n will