Power Fx function
Find — Power Fx function reference
Position of one string in another.
Syntax
powerfx
Find( FindText, WithinText [, StartPosition ] )
Examples
powerfx
Find("@", txtEmail.Text)→ Index or blank
powerfx
Find("@", txtEmail.Text)powerfx
IsBlank(Find(".pdf", Lower(ThisItem.FileName)))Common mistakes & gotchas
- Find returns blank when the text isn't found, unlike many languages' indexOf returning -1 — check with IsBlank() rather than a sentinel number.
- Find is case-sensitive with no built-in case-insensitive variant — normalize both arguments with Lower() first if needed.
Related Power Fx functions
From Text