Showing results for 
Search instead for 
Did you mean: 

Offset / Skip function

Quite often I have the need to skip/offset the first few records of a table/items of a gallery.


In SQL the offset function allows you to specify offset -1 to skip the first row.


I have managed to faciliate this with the help of this community with the below, but it's somewhat complex for such a simple function.


LastN( SortByColumns( Filter( '[dbo].[MyTable]', TextColumn = TextInput1.Text), "DateColumn", Descending), CountRows(Filter('[dbo].[MyTable]', TextColumn = TextInput1.Text)) - 1)

Status: Under Review

Updating status and adding @GregLi

Power Apps
Status changed to: Under Review

Updating status and adding @GregLi

Advocate II

Looking for this feature as well.

Regular Visitor

This would be great!