
Announcements
I am trying to make a collection that will count the number of each response type to a survey. The survey writes to a SharePoint list (pic attached)
ClearCollect(colResults,Filter('After Class Survey', Class = ClassTitle_3.Selected.Value),
The filter is there because the user selects a drop down (classTitle_3)which populates the pie chart.
I believe I declared the collection correctly, and applied the filter correctly, but it won't recognize any column name after that.
Can anyone help me with the formula for the collection?
Hi @AdamG87
Your formula is missing an opening double quote.
Also, the remaining double quotes are 'curly' double quotes, as if they've been copied from Microsoft Word. You'll need to replace them with normal/straight double quotes because Power Apps won't recognise the former.