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

Community site session details

Session Id : L4Pbgh4X8hSgU3tmR7Ctxc
Power Apps - Power Apps Pro Dev & ISV
Suggested answer

Dashboard in Power Apps from a Microsoft List

Like (0) ShareShare
ReportReport
Posted on 28 May 2025 11:37:16 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)
  • stampcoin Profile Picture
    4,328 Super User 2025 Season 2 on 31 May 2025 at 19:16:24
    Dashboard in Power Apps from a Microsoft List
    Please share more information, like screen shot, error message, etc.
  • PT-17031118-0 Profile Picture
    4 on 28 May 2025 at 14:29:48
    Dashboard in Power Apps from a Microsoft List
    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
  • Suggested answer
    stampcoin Profile Picture
    4,328 Super User 2025 Season 2 on 28 May 2025 at 13:44:17
    Dashboard in Power Apps from a Microsoft List
    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 733 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 532 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 399 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete