Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Len function
Applies to: 👁 Image
Canvas apps👁 Image
Copilot Studio👁 Image
Desktop flows👁 Image
Dataverse formula columns👁 Image
Model-driven apps👁 Image
Power Platform CLI👁 Image
Dataverse functions👁 Image
Power Pages
Returns the length of a string of text.
Description
If you specify a single string as the argument, the return value is the length as a number. If you specify a single-column table that contains strings, the return value is a single-column table with a Value column that contains the length of each string. If you have a multi-column table, you can shape it into a single-column table, as working with tables describes.
If you specify a blank string, Len returns 0.
Syntax
Len( String )
- String - Required. The string to measure.
Len( SingleColumnTable )
- SingleColumnTable - Required. A single-column table of strings to measure.
Examples
Single string
For the examples in this section, the data source is a text-input control that's named Author and that contains the string "E. E. Cummings".
| Formula | Description | Result |
|---|---|---|
| Len( Author.Text ) | Measures the length of the string in the Author control. | 14 |
| Len( "" ) | Measures the length of an empty string. | 0 |
Single-column table
For the first example in this section, the data source is named People and contains this data:
| Name | Address |
|---|---|
| "Jean" | "123 Main St NE" |
| "Fred" | "789 SW 39th #3B" |
| Formula | Description | Result |
|---|---|---|
| Len( ShowColumns( People, "Address" ) ) | In the Address column of the People table:
|
A single-column table with a Value column containing the following values: 14, 15 |
| Len( [ "Hello", "to the", "World", "" ] ) | In the Value column of the inline table:
|
A single-column table with a Value column containing the following values: 5, 6, 5, 0 |
Feedback
Was this page helpful?