web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dashboard in Power App...
Power Apps
Suggested Answer

Dashboard in Power Apps from a Microsoft List

(0) ShareShare
ReportReport
Posted on by 4
Hello,
 
I am trying to create a dashboard in power apps from a Microsoft list. I successfully added the sharepoint site as a data source. I have a choice column with the name 'Status' for which i need to create a pie chart. Can you please advise how can i do that?
 
Thanks
I have the same question (0)
  • Suggested answer
    stampcoin Profile Picture
    5,146 Super User 2026 Season 1 on at
    hope this video give you a help.
     
    also some simple version below if you don't want to watch.
     
    1. Insert a Pie Chart control
    In your app, go to Insert → Charts → Pie chart.
    Rename it (e.g. PieChartStatus) so it’s easy to reference.
    2. Build the aggregated data.
    Power Apps charts expect a table with one column for the category (e.g. status text) and one for the value (e.g. count). You can do this on-the-fly in the chart’s Items property, or—if you prefer—a screen’s OnVisible (or the app’s OnStart) by creating a collection.
    Directly in the Pie chart’s Items (no collection needed):
    below is an example ( don't copy it unless you understand the logic)
     
    AddColumns(
      GroupBy(
        AddColumns(
          YourList, 
          "StatusText", Status.Value
        ),
        "StatusText",
        "GroupRecords"
      ),
      "Count",
      CountRows(GroupRecords)
    )
    
     
        YourList = the name of your SharePoint list data source (e.g. SharePointList1).
        AddColumns(...,"StatusText",Status.Value) pulls out the choice’s .Value into a plain text column.
        GroupBy(...,"StatusText","GroupRecords") groups rows by that text.
        AddColumns(...,"Count",CountRows(GroupRecords)) adds a “Count” column of how many items in each group.
    AddColumns(
      GroupBy(
        AddColumns(
          YourList, 
          "StatusText", Status.Value
        ),
        "StatusText",
        "GroupRecords"
      ),
      "Count",
      CountRows(GroupRecords)
    )
    
     
     
     
    3. Configure the Pie chart’s data fields
        Category field (what labels each slice): StatusText
        Value field (size of each slice): Count
        You’ll find these in the right-hand properties pane under Data once the chart is selected.
     
     
    good luck , if you have any question, feel free.
  • PT-17031118-0 Profile Picture
    4 on at
    Hello,
     
    Many thanks for your response. I have gone through that video earlier and tried the same code but the i am getting loads of error (around 9). For example one regarding pie chart saying 'Expected Identifier name', then it says AddColumns has invalid arguments and similar error for Groupby. At one point its also unable to recognize GroupRecords.
     
    Thanks
  • stampcoin Profile Picture
    5,146 Super User 2026 Season 1 on at
    Please share more information, like screen shot, error message, etc.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 530

#2
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#3
Haque Profile Picture

Haque 314

Last 30 days Overall leaderboard