How To Use The Power Apps INDEX Function

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/the-complete-power-apps-functions-list/how-to-use-the-power-apps-index-function/. Author: Matthew Devaney.

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' Code language: JavaScript ( javascript ) The result is: Sarah Green Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up