Power Fx function
Mid — Power Fx function reference
Characters from a position.
Syntax
powerfx
Mid( Text, StartPosition [, NumberOfCharacters ] )
Examples
powerfx
Mid("PowerStack", 6, 5)→ "Stack"
powerfx
Mid(txtPhone.Text, 4, 3)
powerfx
Mid("2026-06-13", 6, 2)Common mistakes & gotchas
- StartPosition is 1-based, not 0-based — Mid("Stack", 1, 1) returns "S".
- Omitting NumberOfCharacters returns everything from StartPosition through the end of the string.
Related Power Fx functions
From Text