Skip to main content
Community site session details
Power Apps - Building Power Apps
Answered

Need help to create pie chart in PowerApps with SharePoint List data

Like (0) ShareShare
ReportReport
Posted on 19 Aug 2021 09:27:36 by 78

Hi, this is my first time to create a pie chart in Power Apps with SharePoint List data. 

 

Currently, I have a SharePoint List named "Learning Tracker" and have a number of column as per below 

 

Hooi_0-1629364519887.png

 

and when employees completed the courses in Digital Transformation/ One Drive/ Teams, SharePoint List will mark "Completed" and All course will mark "Yes". As per example in excel format below: 

 

Hooi_1-1629364915176.png

 

I want to have 5 pie charts show that

1. How many "Completed" in Digital Transformation,

2. How many "Completed" in One Drive and

3. How many "Completed" in TEAMS and also

4. how many "Yes" in All course column

5. How many "Yes" in All course and categorise by Region

 

How can I do so? 

 

  • Verified answer
    rubin_boer Profile Picture
    4,841 Super User 2024 Season 1 on 19 Aug 2021 at 11:54:43
    Re: Need help to create pie chart in PowerApps with SharePoint List data

    hi @Hooi lets go through this and do one for you

     

    This is what we want from the data

    rubin_boer_0-1629373646851.png

     

    (Note i only include the totals for teams, you will have to add the rest). You may also want to create a collection to hold all values whereas i will do the with function in the Items of the Pie chart to illustrate the solution ok.

     

    the PI chart Items = 

     

    With(
     {
     tot: CountRows(colCourses),
     teamsTot: CountRows(
     Filter(
     colCourses,
     teams = "Completed"
     )
     )
     },
     Table(
     {
     Name: "Incomplete(" & tot - teamsTot & ")",
     Total: tot - teamsTot
     },
     {
     Name: "Complete(" & teamsTot & ")",
     Total: teamsTot
     }
     )
    )

     

     

    Hope this helps

     

     

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1