Skip to main content

Notifications

Community site session details

Community site session details

Session Id : P+Eu+kOmO9Mjwr7FmWAuRj
Power Apps - Building Power Apps
Answered

Sharepoint column tally into pie chart

Like (0) ShareShare
ReportReport
Posted on 28 Jun 2022 15:36:21 by

I have a Canvas PowerApp connected to sharepoint that contains a column with a drop down for answer selection. I am trying to make a piechart in powerapps to tally identical answers in the column and display those numbers in a piechart.  I have tried all of the solutions to prior questions that I have seen and nothing seems to be working. 

  • Verified answer
    v-yujincui-msft Profile Picture
    on 01 Jul 2022 at 05:55:39
    Re: Sharepoint column tally into pie chart

    Hi @mswhittle ,

     

    I have made a simple test for your reference.

     

    1. Here is my SharePoint List.

    vyujincuimsft_0-1656654620639.png

    2. Here is my App.

    AddColumns(Choices(DataSource.ChoiceColumnName),"Num",CountRows(Filter(DataSource,ChoiceColumnName.Value=Value)))

    vyujincuimsft_1-1656654799838.png

     

     

    Best Regards,
    Charlie Choi

  • mwhittle1 Profile Picture
    2 on 29 Jun 2022 at 11:00:01
    Re: Sharepoint column tally into pie chart

    this doesnt seem to work, any other ideas?

  • Himanshu_90677 Profile Picture
    416 on 28 Jun 2022 at 19:26:45
    Re: Sharepoint column tally into pie chart

    Building-Power-Apps/Pie-chart-from-Sharepoint-choice-column 

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard