Good day all
I am having an annoying issue with a PowerApp. I have basic SharePoint list with a column called Topic (Choice with a number of choices available for selection). The collection in the app should collect all the topics and then display them without duplicates - I am building an FAQ accordion so the topics will each contain a number of question so topics should only display once.
I have the following formula set on the App OnStart property:
ClearCollect(colTopics,RenameColumns(Distinct(FAQs,Topic),"Result","Topic"));Set(glbTotalTopics,CountRows(colTopics))
When I check Collections to check if it is working, I see the following:

so the results header is correctly adjusted to Topic as per the formula but I do not understand why I am not getting any results - there are a total of 4 distinct Topics in the list.
Any help on this would be greatly appreciated! This is from the FAQ accordion solution Jamie Willis-Rose presented at Global Con 4 so if anyone has reproduced that successfully and can share how they got this part working, it would be great to know.