Len function in PowerApps
Returns the length of a string of text.
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 a blank string, Len returns 0.
Len( String )
- String - Required. The string to measure.
Len( SingleColumnTable )
- SingleColumnTable - Required. A single-column table of strings to measure.
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".
|Len( Author.Text )||Measures the length of the string in the Author control.||14|
|Len( "" )||Measures the length of an empty string.||0|
For the first example in this section, the data source is named People and contains this data:
|Len( ShowColumns( People, "Address" ) )||In the Address column of the People table:
|Len( [ "Hello", "to the", "World", "" ] )||In the Value column of the inline table:
Send feedback about: