How To Use The Power Apps INDEX Function

Summary

The Power Apps INDEX function returns a row from a table by specifying the row number. For example, we could get the 2nd row of a table by supplying the table name and the number 2.

Syntax

Index(Table, Index)

Arguments

Name	Required?	Description
Table	Yes	A table of values.
Index	Yes	The row number in the table to be returned. Top row is 1, the next row is 2, then 3, etc.

Examples

The Customers table contains the following names, addresses and cities.

Full Name	Address	City
Matthew Devaney	115 Main Street	Winnipeg
Sarah Green	45 Henderson Highway	Brandon
Kelly Smith	34 Portage Avenue	Steinbach
David Johnson	10 Commerce Drive	Kenora

To get the 2nd row of the table we can write an INDEX function like this:

Index(Customers, 2)

The result is:

Full Name	Address	City
Sarah Green	45 Henderson Highway	Brandon

We can also use the Power Apps INDEX function to get a value from a specific row of the table. To get the Full Name from the 2nd row we can write this code.

Index(Customers, 2).'Full Name'