Select top n from Azure SQL Databasee

[tom_garvin]

I have an app which works with an Azure SQL Database.

We have a history screen which is intended to list the most recent incidents recorded in the database.

I have an expression which sorts the results, latest at top (i.e. descending).

I do not know how to limit the number of database records returned, which will certainly be to much for a non-delagable query.

I can create a SQL View, but I'd prefer to keep it clean within PowerApps.

In other development tools, I'd use a pass-through query.

Or I'd use a paged control and let the results be sent in chunks, with most users only needing the first n results.

Looking for suggestions on how to approach a solution.

[v-yamao-msft · Accepted solution]

Hi @tom_garvin,

Please try to use FirstN function to return the last set of records of a table.

For your scenario, you could take the following function for a reference:

FirstN(SortByColumns(Filter(Testing2,StartsWith(Title,TextInput1.Text)),"Created",if(SortDescending1,Ascending, Descending)),10)

Please have a try with it and feel free reply if you need more help.

Besides, please post PowerApps related issues on PowerApps forum so that you could get the most qualified answers.

Best regards,

Mabel Mao

[GabrielStJohn]

Hello, @tom_garvin!

Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel

Flow Community Manager

[tom_garvin]

Thank you, Mabel. I got lost on the way to the PowerApps forum, sorry