Power Platform Community Forum Thread Details

Hi, this might be a tricky one to explain but i'll do my best.

I have an App to manage work items. I have a Higher Level screen, with a gallery linking to Sp list 'highlevelplans'

I have a second screen which contains a gallery containing all the lower level plans attached to the selected higher level gallery item selected.

The lower details sp list is lowerlevel plans.

Id like to add a progress bar on the higher level gallery, which shows % or project complete.l based on the status of the lower level details (status choices are 'Not Started', 'In Progress' and 'Complete', there are several iteams in each lower level detail for specific projects.

Thanks in advance.

Categories:

Building Power Apps

Hi @JimboSey

I made a quick small demo with a collection, but you can use it on sharepoint lists as well.

Add two rectangles. The light blue one is the base bar, which represents 100% or full width. The second darker blue bar will then take the width of the light blue one into account. Then you just need to calculate percentage of completed tasks to total tasks: total tasks / completed tasks.

In width property of the dark blue bar you can do something like next:

CountRows(Filter(colTest, status = "complete"))/CountRows(colTest) * (Rectangle1.Width - 24)

Note the '-24' due keeping margin of 12 on each side of the bar. You can also replace the '(Rectangle1.Width - 24)' with the max width (100%) you'd like for the progress bar if you don't need a background bar.

Hope this helps!