Find function
Applies to: 
Canvas apps
Desktop flows
Model-driven apps
Power Pages
Power Platform CLI
Finds a string of text, if it exists, within another string.
Description
The Find function looks for a string within another string and is case sensitive. To ignore case, first use the Lower function on the arguments.
Find returns the starting position of the string that was found. Position 1 is the first character of the string. Find returns blank if the string in which you're searching doesn't contain the string for which you're searching.
Syntax
Find( FindString, WithinString [, StartingPosition ] )
- FindString - Required. The string to find.
- WithinString - Required. The string to search within.
- StartingPosition - Optional. The starting position to start searching. Position 1 is the first character.
Examples
| Formula | Description | Result |
|---|---|---|
| Find("World", "Hello World") | Returns the starting position of "World". | 7 |
| Find("World", "Hello World, Hello World", 10) | Returns the starting position of the first occurrence of "World" after the 10th character. | 20 |
| Find("Mars", "Hello World") | Returns blank since the FindString is not in the WithinString | Blank() |