@surfer1978
You will need to perform a few actions on your SharePoint list to show it in the Chart similar to Excel
- Filter the list by Enrolled=true
- GroupBy Title
- Count the number of rows
I would suggest doing this by creating a Collection. Put this code in the OnVisible property of your screen.
//Group by and count code
ClearCollect(
Filter(myChartData, Enrolled=true),
DropColumns(
AddColumns(
GroupBy(ReportData,"Item","GroupedItems"),
"Count Value",CountRows(GroupedItems)
),
"GroupedItems"
)
);
Now you can add a Bar Chart to your PowerApp and use this code in the Items property to display the data.
myChartData
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
