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.
These functions create and manipulate text values.
Name | Description |
---|---|
Text.InferNumberType | Infers the granular number type (Int64.Type, Double.Type, and so on) of a number encoded in text. |
Text.Length | Returns the number of characters in a text value. |
Name | Description |
---|---|
Character.FromNumber | Converts a number to a text character. |
Character.ToNumber | Converts a character to a number value. |
Guid.From | Returns a GUID value from the given value. |
Json.FromValue | Produces a JSON representation of a given value. |
Text.From | Creates a text value from the given value. |
Text.FromBinary | Decodes data from a binary value in to a text value using an encoding. |
Text.NewGuid | Returns a GUID value as a text value. |
Text.ToBinary | Encodes a text value into binary value using an encoding. |
Text.ToList | Returns a list of characters from a text value. |
Value.FromText | Creates a strongly-typed value from a textual representation. |
Name | Description |
---|---|
Text.At | Returns a character starting at a zero-based offset. |
Text.Middle | Returns the substring up to a specific length. |
Text.Range | Returns a number of characters from a text value starting at a zero-based offset and for count number of characters. |
Text.Start | Returns the count of characters from the start of a text value. |
Text.End | Returns the number of characters from the end of a text value. |
Name | Description |
---|---|
Text.Insert | Inserts one text value into another at a given position. |
Text.Remove | Removes all occurrences of the given character or list of characters from the input text value. |
Text.RemoveRange | Removes count characters at a zero-based offset from a text value. |
Text.Replace | Replaces all occurrences of a substring with a new text value. |
Text.ReplaceRange | Replaces length characters in a text value starting at a zero-based offset with the new text value. |
Text.Select | Selects all occurrences of the given character or list of characters from the input text value. |
Name | Description |
---|---|
Text.Contains | Returns true if a text value substring was found within a text value string; otherwise, false. |
Text.EndsWith | Returns a logical value indicating whether a text value substring was found at the end of a string. |
Text.PositionOf | Returns the first position of the value (-1 if not found). |
Text.PositionOfAny | Returns the first position in the text value of any listed character (-1 if not found). |
Text.StartsWith | Returns a logical value indicating whether a text value substring was found at the beginning of a string. |
Name | Description |
---|---|
Text.AfterDelimiter | Returns the portion of text after the specified delimiter. |
Text.BeforeDelimiter | Returns the portion of text before the specified delimiter. |
Text.BetweenDelimiters | Returns the portion of text between the specified startDelimiter and endDelimiter. |
Text.Clean | Returns the original text value with non-printable characters removed. |
Text.Combine | Returns a text value that is the result of joining all text values with each value separated by a separator. |
Text.Lower | Returns the lowercase of a text value. |
Text.PadEnd | Returns text of a specified length by padding the end of the given text. |
Text.PadStart | Returns text of a specified length by padding the start of the given text. |
Text.Proper | Returns a text value with first letters of all words converted to uppercase. |
Text.Repeat | Returns a text value composed of the input text value repeated a number of times. |
Text.Reverse | Reverses the provided text. |
Text.Split | Returns a list containing parts of a text value that are delimited by a separator text value. |
Text.SplitAny | Returns a list containing parts of a text value that are delimited by any separator text values. |
Text.Trim | Removes all the specified leading and trailing characters. |
Text.TrimEnd | Removes all specified trailing characters. |
Text.TrimStart | Removes all specified leading characters. |
Text.Upper | Returns the uppercase of a text value. |
Training
Module
Text manipulation in Power Automate for desktop - Training
Learn how to manipulate text and datetime values in Power Automate for desktop.