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,
Solved! Go to Solution.
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).
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).
Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
255 | |
205 | |
76 | |
37 | |
31 |
User | Count |
---|---|
331 | |
214 | |
121 | |
71 | |
55 |