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)

v-bofeng-msft on at

Like (0)

Report
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 (0)

Report

Hi @v-bofeng-msft!

I added above but got this error message:

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation