cancel
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

Comments
CWesener
Power Apps
Status changed to: Under Review

Updating status and adding @GregLi

BARD
Advocate II

Looking for this feature as well.

bgigliotti
Regular Visitor

This would be great!