Hi,
I have a table imported from an excel spreadsheet to which I want to add three columns.
The issue I'm having is that the third column is calculated off the other two.
When I try to add them all in the Items formula using AddColumns I can't get the third to access the first two as they dont' exist yet (at least that's what I think is happening).
Is there a way to add columns outside of Items?
Cheers
You can do it with th OnSelect property of a button or in the OnVisible property of the screen containing the gallery. The syntax is
ClearCollect(colDatasource, Yourdatasource)
The Items property of the datatable or gallery would be
AddColumns(colDatasource,”formulaname”,calculation,”formulaname2”,calculation2,etc.)
Hi @Lewkir,
Please try creating a collection from your static datasource and then add the calculated columns. You should be able to display the results in a gallery or datatable as well as shaping the collection by filtering, sorting, renaming columns, etc. The main advantages are that you can create collections from very large datasources, all functions will work regardless of delegation, and they will be lightning fast.
The disadvantage is that you won’t be able to save them unless you create another datasource to save them to.