Filter on datatable or Datasource

[Boynogs123]

Hi,

How can I filter the datatable, I want only show the 1 - 20 records of my datasource I already try this  CountRows('FinalDataSource') <= 20 but it shows nothing.

Thanks!

best regards

Boynogs

[shailendra74 · Accepted solution]

Hi @Boynogs123 

You need to use FirstN method:

FirstN(Sort(Filter(...)), 20)

FirstN( Table , 20 )

you can refer to 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-first-last

Thanks.

[Boynogs123]

Hi @shailendra74 ,

Thank you ! 

Do know how to make it like pagination?

Thank you!

Best Regards,

Bernard