web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dropdwon Filter, Visib...
Power Apps
Unanswered

Dropdwon Filter, Visible Property and based upon SP Value

(0) ShareShare
ReportReport
Posted on by 643

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.

 

jamescosten_0-1701168781424.pngjamescosten_1-1701168791187.png

jamescosten_2-1701168799668.pngjamescosten_3-1701168814214.png

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:
I have the same question (0)
  • Hassan_SZ_365 Profile Picture
    542 on at

    Hi @jamescosten ,

     

    Follow these steps:

    1. 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.

    2. Variable for Current Page: Create a variable to track the current page, e.g., varCurrentPage.

    3. 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 419

#2
WarrenBelz Profile Picture

WarrenBelz 397 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 345 Super User 2025 Season 2

Last 30 days Overall leaderboard