Hello Everyone,
Hoping to get some help here, I am trying to create a table collection from a table in Excel. I created a button with the following formula in the OnSelect property:
ClearCollect(colHistory, SortByColumns(Filter(History, Not(IsBlank(Date)) && Not(IsBlank(Close))),"Date",SortOrder.Descending)) //History is a table from Excel
DropColumns(colHistory,"Days","High","Low","Open","Volume")
Last night, it was working except for it added all the columns in the collection. I saved and closed it to work on removing the unwanted columns the next morning. This morning, upon running it, it gave me this error:
So I removed the SortByColumns, which resolved the error; however, here are some issues that I am now encountering:
- The button is showing a Delegation warning: The highlighted part of this formula might not work correctly on large data sets. The "And" operation is not supported by this connector.
- The colHistory collection is not returning the updated data, even after refreshing the History data.
- The data seems inacurate. Please check the prices and the date
- The colHistory collection, is returning all columns and all blank rows
My objective is:
- I want to create a collection with just 2 columns (Date and Close ONLY) from an Excel Table with 7 columns and 260 rows.
- The collection must not include blank rows
- The collection data must be accurate
Thanks in advance.
