Training
Module
Text manipulation in Power Automate for desktop - Training
Learn how to manipulate text and datetime values in Power Automate for desktop.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Text.Combine(texts as list, optional separator as nullable text) as text
Returns the result of combining the list of text values, texts
, into a single text value. Any null
values present in texts
are ignored. An optional separator
used in the final combined text can be specified.
Combine text values "Seattle" and "WA".
Usage
Text.Combine({"Seattle", "WA"})
Output
"SeattleWA"
Combine text values "Seattle" and "WA", separated by a comma and a space.
Usage
Text.Combine({"Seattle", "WA"}, ", ")
Output
"Seattle, WA"
Combine the values "Seattle", null
, and "WA", separated by a comma and a space. (Note that the null
is ignored.)
Usage
Text.Combine({"Seattle", null, "WA"}, ", ")
Output
"Seattle, WA"
Usage
Combine the first name, middle initial (if present), and last name into the individual’s full name.
let
Source = Table.FromRecords({
[First Name = "Doug", Middle Initial = "J", Last Name = "Elis"],
[First Name = "Anna", Middle Initial = "M", Last Name = "Jorayew"],
[First Name = "Rada", Middle Initial = null, Last Name = "Mihaylova"]
}),
FullName = Table.AddColumn(Source, "Full Name", each Text.Combine({[First Name], [Middle Initial], [Last Name]}, " "))
in
FullName
Output
Table.FromRecords({
[First Name = "Doug", Middle Initial = "J", Last Name = "Elis", Full Name = "Doug J Elis"],
[First Name = "Anna", Middle Initial = "M", Last Name = "Jorayew", Full Name = "Anna M Jorayew"],
[First Name = "Rada", Middle Initial = null, Last Name = "Mihaylova", Full Name = "Rada Mihaylova"]
})
Training
Module
Text manipulation in Power Automate for desktop - Training
Learn how to manipulate text and datetime values in Power Automate for desktop.