Unanswered

Creating a collection from another collection by selecting the chosen column

(0) Share

Report

Posted on by mrwilliams

I have a collection of data called PupilMathData which has lots of columns. I want to create another collection, with two columns from that larger collection so I can chart it. One column needs to be the test name, and I want the user to choose the other column (the one they want to view on the graph) from a dropdown.

What I have tried here is to assign the selected value from the dropdown to a variable, and use that variable as the column to add into the new collection called MathChartData, but I get the error 'Argument DisplayChart is invalid. Expected a text literal' - as the showcolumns function like the columns in quotes. Any ideas on how I can do this?

Once these two columns are in a separate collection, I will use that collection for the datasource of the bar chart.

Set(DisplayChart,MathChartSelection.SelectedText.Value);
ClearCollect(MathChartData, ShowColumns(PupilMathsData,"Test",DisplayChart))

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mrwilliams ,

When you use ShowColumns, you need the actual column name in Quotes. What are the options selected from the drop-down ?
mrwilliams 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

The drop down list contains the names of the columns in the master collection - which are also the same as the datatable which is pulling its data from this collection too.

The drop down coloumn items:

Then PupilMathData collection:
The items in the dropdwon are the same as the dable headings:
Does that help?
WarrenBelz 156,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@mrwilliams ,

Unfortunately, you cannot reference a column name dynamically like that.