cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marc2510
Helper III
Helper III

Progress/completion bar/pie

How would I go about creating a progress bar?

 

currently I have a simple flat sharepoint list as a data source

 

Columns

 

Title = task name
School = who does the task (choice field)
Status = Complete/not complete

 

I would like to display in a % of much is left to do for the school.
if school has 100 tasks to do and has completed 10 it would be nice to display 10% done

 

Gallery's are always filtered per school.

Sorry for not much detail - struggling to find the words to explain what i mean!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @marc2510 :

I've made a test for your reference:
1\I assume there is a table:

ClearCollect(
  SchoolTask,
  {Title:"Task1",School:"School1",Status:"Complete"},
  {Title:"Task2",School:"School1",Status:"not complete"}, 
  {Title:"Task3",School:"School2",Status:"Complete"}
)

2\Add a gallery and set it's items property to:

AddColumns(
    GroupBy(SchoolTask,"School","NewGroup"),
   "CompleteProgress",
   CountRows(Filter(NewGroup,Status="Complete"))/CountRows(NewGroup)
)

3\Add a label control in to this gallery

Text

ThisItem.School

4\Add an other label control control in to this gallery

Width

800*ThisItem.CompleteProgress

Text

ThisItem.CompleteProgress *100&"%"

Fill

Green

vbofengmsft_0-1632278611031.png

Best Regards,

Bof

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @marc2510 :

I've made a test for your reference:
1\I assume there is a table:

ClearCollect(
  SchoolTask,
  {Title:"Task1",School:"School1",Status:"Complete"},
  {Title:"Task2",School:"School1",Status:"not complete"}, 
  {Title:"Task3",School:"School2",Status:"Complete"}
)

2\Add a gallery and set it's items property to:

AddColumns(
    GroupBy(SchoolTask,"School","NewGroup"),
   "CompleteProgress",
   CountRows(Filter(NewGroup,Status="Complete"))/CountRows(NewGroup)
)

3\Add a label control in to this gallery

Text

ThisItem.School

4\Add an other label control control in to this gallery

Width

800*ThisItem.CompleteProgress

Text

ThisItem.CompleteProgress *100&"%"

Fill

Green

vbofengmsft_0-1632278611031.png

Best Regards,

Bof

 

marc2510
Helper III
Helper III

Perfect thank you

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,115)