Text.Split
Text.Split(text as text, separator as text) as list
Returns a list of text values resulting from the splitting a text value text
based on the specified delimiter, separator
.
Create a list from the "|" delimited text value "Name|Address|PhoneNumber".
Usage
Text.Split("Name|Address|PhoneNumber", "|")
Output
{
"Name",
"Address",
"PhoneNumber"
}