Power Platform Community Forum Thread Details

Is there a way to create a collection from a filter (on a sharepoint list) that doesn't end up with the collection containing tables? I have this:

ClearCollect(ChartTest, Filter( 'TestList', StudentId = Student.StudentId ))

which creates a collection where each column from TestList is a table. e.g. Student.Grade1 will have multiple entries in the Sharepoint list. This means the chart won't use the ChartTest collection as it expects numbers rather than tables:

"The property expects Number values, but this rule produces incompatible Table values"

and I can't seem to tell it to use ChartTest.Grade1.Value for the Y axis. What I need is the tables from the filter turned into a collection the line chart can read.

thanks,

Alistair

Categories:

Building Power Apps