You’re offline. This is a read only version of the page.
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.
@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:
Share
Report
All responses (
Answers (
With(
{
_passed: Filter(
'Your Data',
'Your Choice Column'.Value = "Pass"
)
},
((CountRows(_passed) / Gallery1.AllItemsCount) / 100 * Button1.Width) * 100
)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 :
@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
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
