Power Platform Community Forum Thread Details

I have the follwoing Screen On my App to track checks on boxes in production. It works well but i need to make the selection of numbers expandable to over 100 dropdowns. I want to put pages in that show 50 selections at a time and need to change the visible property of the item as well as ensuring the On Change and Default Properties works.

If a job has 10 boxes then only dropdown 1-10 show everything else is hidden. If we have 67 boxes i want the Page 1 1-50 to be visible and when you go to page 2 boxes 51-67 are visible and the rest hidden.

Categories:

Building Power Apps

Hi @jamescosten ,

Follow these steps:

Variable for Box Count: First, ensure you have a variable that holds the total count of boxes for a job. Let's call this varBoxCount.
Variable for Current Page: Create a variable to track the current page, e.g., varCurrentPage.
Visible Property of Dropdowns: Set the Visible property of each dropdown to determine if it should be displayed. For dropdowns 1-50, use something like:

varCurrentPage = 1 && varBoxCount >= DropdownNumber

For dropdowns 51-100 (on page 2), adjust the formula accordingly:

varCurrentPage = 2 && varBoxCount >= (DropdownNumber - 50)

Replace DropdownNumber with the actual number of the dropdown.

Page Navigation Controls: Add buttons or controls to navigate between pages. These controls will update varCurrentPage.
OnChange and Default Properties: Ensure that the OnChange property of each dropdown performs the necessary action when a selection is made. The Default property should be set according to your application logic, possibly using the saved data or a default value.
Dynamic Pagination: If you have more than two pages, consider implementing a more dynamic way to handle the pagination, possibly using a formula that calculates the range of dropdowns to be shown based on varCurrentPage.

Best Regards,

Hassan Raza