Power Fx function
Left / Right — Power Fx function reference
Characters from one end.
Syntax
powerfx
Left( Text, NumberOfCharacters ) / Right( Text, NumberOfCharacters )
Examples
powerfx
Left("PowerStack", 5)→ "Power"
powerfx
Left(txtSKU.Text, 3) = "PO-"
powerfx
Right(ThisItem.FileName, Len(ThisItem.FileName) - Find(".", ThisItem.FileName))Common mistakes & gotchas
- If NumberOfCharacters exceeds the string length, Left/Right simply return the whole string rather than erroring or padding.
- Both count Unicode characters, not bytes, so results with emoji or combining characters can differ from server-side string APIs.
Related Power Fx functions
From Text