Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Find function
Applies to: 👁 Image
Canvas apps👁 Image
Copilot Studio👁 Image
Desktop flows👁 Image
Model-driven apps👁 Image
Power Platform CLI👁 Image
Dataverse functions👁 Image
Power Pages
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() |
Feedback
Was this page helpful?