cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alonso_96
Frequent Visitor

Mass requests

Hi,

 

I want to create a form or a gallery, but the client needs to type the number of rows he wants to full.

Do you know any formula works like that.

The creator needs to type the number 40 

Number of Rows = 40

 

So a gallery can create 40 rows.

 

Thanks,

 

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User II
Super User II

@Alonso_96 

The gallery can be limited to the first 50 rows FirstN(Sort(yourlist, ID, Ascending), 50) or

the Last 50 with FirstN(Sort(yourlist, ID, Descending),50)  If you wanted to let the user put in the number of rows you could add a slider with a minimum of 1 and a maximum of 500 or the maximum number in your list and set the formula to 

FirstN(yourlist, ID, Ascending), Slider1.Value) or the last records FirstN(yourlist, ID, Descending), Slider1.Value)._1.png

View solution in original post

1 REPLY 1
Drrickryp
Super User II
Super User II

@Alonso_96 

The gallery can be limited to the first 50 rows FirstN(Sort(yourlist, ID, Ascending), 50) or

the Last 50 with FirstN(Sort(yourlist, ID, Descending),50)  If you wanted to let the user put in the number of rows you could add a slider with a minimum of 1 and a maximum of 500 or the maximum number in your list and set the formula to 

FirstN(yourlist, ID, Ascending), Slider1.Value) or the last records FirstN(yourlist, ID, Descending), Slider1.Value)._1.png

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (50,400)