cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Filter on datatable or Datasource

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

 

1234.PNG

123.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Filter on datatable or Datasource

Hi @Anonymous 

 

You need to use FirstN method:

 

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

 

 

FirstNTable , 20 )

 

you can refer to 

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

 

Thanks.

View solution in original post

2 REPLIES 2
Highlighted
Anonymous
Not applicable

Re: Filter on datatable or Datasource

Hi @Anonymous 

 

You need to use FirstN method:

 

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

 

 

FirstNTable , 20 )

 

you can refer to 

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

 

Thanks.

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Filter on datatable or Datasource

Hi @Anonymous ,

 

Thank you Smiley Happy

 

Do know how to make it like pagination?

 

Thank you!

 

Best Regards,

Bernard

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,544)