cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

New collection from another collection

i have one collection that has say 12,000 records in it.  I want to take the first 4000 records and create a new collection of just these.  There is nothing in the collection that i can filter on, it just the first 4000 items.  First does not work because i cannot give a count to it.  What other way can get this done.  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: New collection from another collection

NeverMind.  Brain Fart...

View solution in original post

2 REPLIES 2
Highlighted
Helper III
Helper III

Re: New collection from another collection

NeverMind.  Brain Fart...

View solution in original post

Highlighted
Microsoft
Microsoft

Re: New collection from another collection

@wsalling 

 

You can create collection with specific amount of rows using the FirstN function.

In the FirstN function you can specify the number of rows that you want to be extracted and based on that you can create a new collection.

 

You can check the documentation for reference regarding the same.

 

I am also pasting the sample data so that you can use it as reference.

ClearCollect(test,{index:1},{index:2},{index:3},{index:4},{index:5},{index:6},{index:7}) - Create collection

 

ClearCollect(testa,FirstN(test,5)) - Filtered collection.

 

If the information helps you, please consider giving a thumbs up and mark solution as resolved.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,900)