Pie chart from collection

(0) Share

Report

Posted on by CG83

Hi all,

I have read alot of info around charts in Power Apps, but just cannot get mine to return any values!

I have created a collection in my apps 'OnStart property as below:

Set(varCurrentUser, LookUp(Users, Email = User().Email));

ClearCollect(
colFinishedPredictions,
Filter(Predictions, LookUp(Events, EventFinal = EventName).EventFinished = "Yes")
);

ClearCollect(
colPredictionsSummary,
{
PredictionType: "Gold",
Count: CountRows(Filter(colFinishedPredictions, Points = 5))
},
{
PredictionType: "Silver",
Count: CountRows(Filter(colFinishedPredictions, Points = 3))
},
{
PredictionType: "Bronze",
Count: CountRows(Filter(colFinishedPredictions, Points = 1))
},
{
PredictionType: "Incorrect",
Count: CountRows(Filter(colFinishedPredictions, Points = -1))
},
{
PredictionType: "No Prediction",
Count: CountRows(Filter(colFinishedPredictions, Points = 0))
}
);

Then within my pie chart I have set the 'items' property to 'colPredictionsSummary' , with PredictionType and Count added as data points

In my pie chart, this is not returning anything! As below:

I cant establish what I am doing wrong with this, but this is the final step of my app so REALLY frustrating that I cant get it right. Is anybody able to point out the (hopefully obvious) mistake that I am making?

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

Pie charts will appear like this if all the values are zero.

It looks like the most likely reason for this is that the CountRows(...) are all returning zero.

What column type is points?

If it's not numerical, try replacing the "colFinishedPredictions" with "Value(colFinishedPredictions)"

Let me know how it goes!
CG83 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply. You are right. The countrows steps are returning a value of 0 (I added a text label to test each of these).
I even removed the filter section and just checked
CountRows(colFinishedPredictions)
This returns a 0 value as well which I guess means the issue is with the section of the onstart code
ClearCollect(
'colFinishedPredictions',
Filter(Predictions, LookUp(Events, EventFinal = EventName).EventFinished = "Yes")
);

I have checked within excel that the text in EventFinal matches the text in EventName and it does.

I am baffled!
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@CG83

Just looking at this ClearCollect here, and I just want to confirm what you're getting. How do your data sources 'predictions' and 'events' relate?

I suspect you have to change the ClearCollect() a bit here.

Let me know!
CG83 55 on at

Like
a
(0)

Report
Copy link

Link copied!

So..... My 'events' table looks as below:

This holds all of the event info and shows if the event remains open.

Then the 'Predictions' table looks like this:

I guess my Pie Chart needs to get a list of events from the 'events' table that have finished then cross reference these in the predictions table, filter by user and then show the medal allocation?
CG83 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Can anybody help with this?
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CG83 ,

The first problem is this

ClearCollect( colFinishedPredictions, Filter( Predictions, LookUp( Events, EventFinal = EventName ).EventFinished = "Yes" ) );

You are filtering Predictions, but then looking up Events without any referral to the field in Predictions that needs to match whatever those records return. It seems from your table images that it is EventName so try this

ClearCollect( colFinishedPredictions, Filter( AddColumns( Predictions, Finished, LookUp( Events, EventFinal = EventName ).EventFinished ), Finished = "Yes" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps