web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Pie chart based on Sha...

Power Apps

Unanswered

Pie chart based on SharePoint List text column

(0) Share

Report

Report

Posted on by jaanihsm

300

Hi! I have a SharePoint list called 'Template' and within a column called 'Status'.

Issue Status can have ABC, XYZ and other text values. How do I show the sum of each value within this column in a pie chart?

I've tried GroupBy but cannot figure out the correct formula. Thanks for your help!

SP List Name: Template

Column: Status

Status Text Values: ABC, XYZ, etc...

Pie chart to show how many ABC, XYZ in the whole list.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jaanihsm ,

Please try:

AddColumns( GroupBy( ListName, "Status", "NewGroup" ), "Count", CountRows(NewGroup) )

Best Regards,

Bof

Was this reply helpful? Yes No
jaanihsm 300 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft!

I added above but got this error message:

Was this reply helpful? Yes No
jaanihsm 300 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft! Any recommendations to go about the nested tables warning? Thank you!

Was this reply helpful? Yes No

Join the conversation