String Functions in Power Automate - Beginners Tutorial

This Microsoft Power Automate tutorial for beginners teaches you how to use string functions. With an example for each function, you're guaranteed to master manipulating text in Power Automate.

VIDEOS FOR YOU:

POWER AUTOMATE GROUPS:
- Join my network with 4600+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!

FOLLOW ME:

0:00 Create Strings to Work With
We initialize two variables - both of the type string. Then, we will apply our Power Automate functions to these strings.

2:03 concat
The concat function combines text.

5:06 substring
The substring function returns characters from a specified position. It's optional to set an ending position.

9:25 slice
The Slice string function in Power Automate is an improvement to the Substring. For the starting position, you can use negative numbers - which lets you extract characters from the end of the string.

12:52 replace
The replace function substitute one string with another string inside a string.

15:11 toUpper
When comparing two strings from different systems, its helpful to transform them to upper (or lower) cases using the Power Automate string function, toUpper/toLower.

16:35 indexOf
Search for a string inside a string and return the index of the first occurrence.

18:25 nthIndexOf
Search for the nth occurrence of a string inside a string with this string function.

21:02 lastIndexOf
Search for the last occurrence of a string in a string with the lastIndex string function.

22:40 startsWith
Check if a string starts with a text. Returns a boolean - true or false.

24:33 split
A split function splits a string by a separator into an array of strings. This array can be referred to by an index or an Apply to each action.

30:36 trim
A trim removes whitespace at the start and end of a text.

#powerautomate #powerplatform #microsoft365

[andersjensenorg]

Network and solve Power Automate problems with almost 5000 automation developers 👇
Thanks for all your support 🙌❤

[khaledalaqqad]

My Brother Jazakum Allah Kul Khair (Thank You) very well explanation

[suraj_singh]

Great video sir make a video on Extract specific data from word and write it to Excel using PAD

[QaisNL]

Im enjoying and learning a lot thx👍👍👍👍

[einghonphoo]

Thank you for the video. I'm facing am issue in using concatenation function. What i want to do is to add line break between each variable. For example,
Apple
Orange.
I added \n. But when i populate it to docs template, it's just showing as applie\n orange. It's not rendering properly as I wanted. Could you please help me to solve it. I tried adding enter key in variable as well. It didn't work

[ezelkarlkl]

Could you share an example about "get web data from single url multiple tabs"

concat('Harry', ' ', 'Potter')

[tusharswamy]

Why this video doesn't have option to watch in higher quality, this is blury video.

Great intro to string manipulation in Power Automate. Have you tried to add Dynamic content into your expressions? E.g. start typing your expression, e.g. concat( after that click over Dynamic content and select first variable, then you can you add a comma, click on the dynamic content and select the second variable and then type the closing parenthesis and ctrl-A, Ctrl-C and click done. In the new experimental expression window, it is called Dynamic values, so you can add those directly into the input or as part of expression from below.