You’re offline. This is a read only version of the page.
141
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
Share
Report
All responses (
Answers (
