Hi @s_tanswell84
Based on the information you have provided, I made a Screen with a Container for the Pie Chart.
The List data looks like this with a Column named "Feedback":
Copy this code and use the new "Paste"-"Paste Code <Preview>" feature to paste it into your Power App.
- con_PieChart:
Control: GroupContainer
Variant: manualLayoutContainer
Properties:
Height: =933
Width: =626
Y: =60
Children:
- comp_PieChartGroup:
Control: Group
Children:
- legend_PieChart:
Control: Legend
Properties:
Items: =Sort(pie_PieChart.SeriesLabels,Value,SortOrder.Descending)
Height: =283
ItemColorSet: =pie_PieChart.ItemColorSet
Size: =16
Width: =534
X: =40
Y: =650
- pie_PieChart:
Control: PieChart
Properties:
Items: =colDistinctChoicesAndCounts
Height: =570
Width: =534
X: =40
Y: =83
- lbl_PieTitle:
Control: Label
Properties:
Text: ="Chart Title"
Align: =Align.Center
Height: =36
Size: =14
Width: =534
X: =40
Y: =40
- btn_LoadData:
Control: Classic/Button
Properties:
OnSelect: |
=ClearCollect(
colFeedbackItems,
'YourSharePointListGoesHERE'
);
Clear(colAllChoices);
ForAll(
colFeedbackItems As FeedbackItem,
ForAll(
ParseJSON(FeedbackItem.Feedback) As FeedbackChoice,
//Assumes Feedback is a text field in the format
//["Poor communication/Lack of updates","Poor technical skills","Other"]
Collect(
colAllChoices,
{
ChoiceValue: Text(FeedbackChoice)
}
)
)
);
ClearCollect(
colDistinctChoicesAndCounts,
AddColumns(
GroupBy(
colAllChoices,
ChoiceValue,
Count
),
DistinctCount,
CountRows(Count),
LabelWithCount,
$"{ChoiceValue} ({CountRows(Count)})"
)
);
Text: ="Load Data"
Width: =184
X: =432
Y: =27
Update the 'YourSharePointListGoesHERE' with your SharePoint List data source. The button has the code to create the Collection for the Pie Chart.
ClearCollect(
colFeedbackItems,
'YourSharePointListGoesHERE'
);
Clear(colAllChoices);
ForAll(
colFeedbackItems As FeedbackItem,
ForAll(
ParseJSON(FeedbackItem.Feedback) As FeedbackChoice,
//Assumes Feedback is a text field in the format
//["Poor communication/Lack of updates","Poor technical skills","Other"]
Collect(
colAllChoices,
{
ChoiceValue: Text(FeedbackChoice)
}
)
)
);
ClearCollect(
colDistinctChoicesAndCounts,
AddColumns(
GroupBy(
colAllChoices,
ChoiceValue,
Count
),
DistinctCount,
CountRows(Count),
LabelWithCount,
$"{ChoiceValue} ({CountRows(Count)})"
)
);
Hopefully this gets you what you need.
-Mark
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up.
