Power Fx function
StartsWith / EndsWith — Power Fx function reference
Test a prefix or suffix.
Syntax
powerfx
StartsWith( Text, Start ) / EndsWith( Text, End )
Examples
powerfx
StartsWith(txtFile.Text, "PO-")
→ true / false
powerfx
StartsWith(Lower(txtEmail.Text), "admin@")
powerfx
EndsWith(ThisItem.FileName, ".pdf")
Common mistakes & gotchas
- Both are case-sensitive by default — wrap both sides in Lower() for a case-insensitive check.
- StartsWith/EndsWith are delegable on most modern connectors (SharePoint, Dataverse), making them a better filter choice than combining Left/Right with = on large tables.
Related Power Fx functions
From Text