Answered

Gallery Completion Progress Bar

(0) Share

Report

Posted on by nshaw75

440

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Amik

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Amik
I have watched the YouTube videos and like the look of the "Button" progress bar in DamoBird's video
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.

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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 )

Was this reply helpful? Yes No
nshaw75 440 on at

Like (1)

Report
Copy link

Link copied!

Fantastic @Amik ,
You are a genius 🙂

Thanks you very very much

Was this reply helpful? Yes No