Collecting only certain columns with ShowColumns and a filter

[krickard]

I have a few statements that I'm attempting to merge together that aren't passing syntax validation. I'm unsure how to best nest these statements. 

First off I have a SP list of data that I want to copy to a collection. This works by itself except that it pulls all kinds of strange columns names like "OData_..." and even changes exiting SP column names to cryptic ones such as "ooyw". 

ClearCollect(colsavedsurvey,Filter(savedsurvey,saved_surveyname = ThisItem.Result));

I came across a post that talked about using ShowColumns to collect just the columns I want from the SP list. Something like this...

ClearCollect(stage,ShowColumns(colsavedsurvey, "saved_surveyname", "saved_category", "saved_question", "saved_qid", "saved_answer1", "saved_answer1points", "saved_answer2", "saved_answer2points", "saved_answer3", "saved_answer3points", "saved_answer4", "saved_answer4points", "saved_answer5", "saved_answer5points"));

BTW... secondary problem, it does not like this ShowColumns code, says the columns don't exist.  

So the ask is... How do I use a collect with a filter to only select certain columns from a SP list into a collection?  I've tried this as well, with no good results...

ClearCollect(colsavedsurvey,Filter(savedsurvey,saved_surveyname = ThisItem.Result), ShowColumns(colsavedsurvey, "saved_surveyname", "saved_category", "saved_question", "saved_qid", "saved_answer1", "saved_answer1points", "saved_answer2", "saved_answer2points", "saved_answer3", "saved_answer3points", "saved_answer4", "saved_answer4points", "saved_answer5", "saved_answer5points"));

Thanks in advance for your thought cycles. Let me know if there is additional information that would help. 

[v-xida-msft]

Hi @krickard ,

Is the double quotes ("") helpful for your scenario?

If the double quotes ("") I mentioned above is also helpful in your scenario, please also consider go ahead to click "Accept as Solution" to identify my reply as helpful.

Regards,