Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Gallery Completion Progress Bar

(0) ShareShare
ReportReport
Posted on by 363

I have a gallery of checks in an audit and in that I have a choice column of the check status. In this column there are 4 choices Pass, Fail, N/A and Untested. I seem to be able to find similar answers which apply to a form but I want the whole list counted.

 

I am wanting to show a progress bar, including a text label, showing the percentage of the checks which have been completed. ie a;; tasks that <>Untested.

 

 

Categories:
  • nshaw75 Profile Picture
    nshaw75 363 on at
    Re: Gallery Completion Progress Bar

    Fantastic @Amik ,

    You are a genius 🙂

     

    Thanks you very very much

  • Verified answer
    Ami K Profile Picture
    Ami K 15,650 on at
    Re: Gallery Completion Progress Bar

    @nshaw75 - you're going to need to incorporate your solution into his solution using math. If your percentage value is 60% for example, you will need to identify what 60% is of the Button width:

     

    With(
     {
     _passed: Filter(
     'Your Data',
     'Your Choice Column'.Value = "Pass"
     )
     },
     ((CountRows(_passed) / Gallery1.AllItemsCount) / 100 * Button1.Width) * 100
    )
  • nshaw75 Profile Picture
    nshaw75 363 on at
    Re: Gallery Completion Progress Bar

    Thanks @Amik 

    I have watched the YouTube videos and like the look of the "Button" progress bar in DamoBird's video 

    nshaw75_0-1713090540564.png

    I have managed to successfully copy the example, although this uses a collection of data. In the text property it  uses the code :

     

    Button1.Width/CountRows(colstages)*CountIf(colstages,Completed=true)
     
    colstages being the collection being referred to. When I want to use this I have tried replacing colstages with gallery1 or mySPlist. I have tried using commas and semi colons. I am obviously getting the syntax wrong.
  • nshaw75 Profile Picture
    nshaw75 363 on at
    Re: Gallery Completion Progress Bar

    Thanks @Amik 

  • Verified answer
    Ami K Profile Picture
    Ami K 15,650 on at
    Re: Gallery Completion Progress Bar

    @nshaw75 - to display the percentage on a Label control, you can use either:

     

    With(
     {
     _passed: Filter(
     'Your Data',
     'Your Choice Column'.Value = "Pass"
     )
     },
     Text(
     CountRows(_passed) / Gallery1.AllItemsCount * 100,
     "#%"
     )
    )
    

     

    Same is above but looking at the data source directly:

     

    With(
     {
     _passed: Filter(
     'Your Data Data',
     'Your Choice Column'.Value = "Pass"
     )
     },
     Text(
     CountRows(_passed) / CountRows('Your Data') * 100,
     "#%"
     )
    )
    

     

    For the progress indicator, there are many creative methods you can find online together with the Progress Bar control (in preview).

     

    https://www.youtube.com/watch?v=GGIP_hQ3uv8 

     

    https://www.youtube.com/watch?v=r-bTu1srBkY 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard