Answered

Sharepoint column tally into pie chart

Like (0) Share

Report

Posted on 28 Jun 2022 15:36:21 by mswhittle

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.

Categories:

Using Apps Using Formulas

Connecting to Data

All responses (3)

Answers (1)

Verified answer

v-yujincui-msft on 01 Jul 2022 at 05:55:39

Like (0)

Report
Re: Sharepoint column tally into pie chart

Hi @mswhittle ,

I have made a simple test for your reference.

1. Here is my SharePoint List.

2. Here is my App.

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

Best Regards,
Charlie Choi
mwhittle1 2 on 29 Jun 2022 at 11:00:01

Like (0)

Report

Re: Sharepoint column tally into pie chart

this doesnt seem to work, any other ideas?
Himanshu_90677 416 on 28 Jun 2022 at 19:26:45

Like (0)

Report

Re: Sharepoint column tally into pie chart

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