Len function in PowerApps

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 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 an empty 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:

Formula Description Result
Len( ShowColumns( People, "Address" ) ) In the Address column of the People table:
  • Measures the length of each string.
  • Returns a single-column table that contains the length of each string.
Len( [ "Hello", "to the", "World", "" ] ) In the Value column of the inline table:
  • Measures the length of each string.
  • Returns a single-column table that contains the length of each string.