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)
Updating status and adding @GregLi
Looking for this feature as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.