Find function

Applies to: Canvas apps Desktop flows Model-driven apps 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 occurence of "World" after the 10th character. 20
Find("Mars", "Hello World") Returns blank since the FindString is not in the WithinString Blank()