FirstN??

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

If I have a column with a sortorder and use the following formula to order.

SortByColumns('[dbo].[SurveyQuestions]',"SortOrder")

How do I return a record at row 2..3.. etc

Something like

FirstN(SortByColumns('[dbo].[SurveyQuestions]',"SortOrder"), 2).Question

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

If you would like to return a single record, we could take use of Lookup function.

For Multiple records, function filter, search should be able to deal with that:

Filter, Search, and Lookup functions in PowerApps

So here if you would like to show the Question value of the second row from the SQL Table, we could write the formula as below:

Lookup(SortByColumns('[dbo].[SurveyQuestions]',"SortOrder"), SortOrder=2).Question

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
There's no "indexing" function in PowerApps where you can retrieve a specific record by its position; but you can use a combination of the FirstN and Last functions to accomplish that.

In your case, if you want the second item in your (sorted) list of items, you can use the following expression:

Last(FirstN(SortByColumns('[dbo].[SurveyQuestions]', "SortOrder"), 2)).Question
Can you explain what is your scenario where you want to retrieve a specific item (by position) of your data source? It would be interesting to know why you need that functionality. Thank you!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CarlosFigueira,

Perfect workaround. I use the indexing to return a specific row for a list of questions in a database. The table has an orderBy column however the values are not sequential. e.g. 10 , 20 , 30 I presume this is so they can insert more later without requiring multiple updates.

Cheers
Jeremy

Was this reply helpful? Yes No