Hey there
So I've been playing around with CDS as so far I'm not really convinced. At this time, I'd rather stick to SharePoint as a data source as it seems more reliable. However - and this is probably more likely - I might be doing something wrong.
I have created an entity called "Transactions". All the fields in this entity are text fields.
My problem is the following:
On App.OnStart I'm executing the following commands:
1) ClearCollect(colTransactions, Transactions);
So far so good. When I check the colTransactions collection I can see all data the way they should be. However, I'd like to group those transactions by month. That's why I'm adding the second command to the App.OnStart:
2) ClearCollect(colMonthsGrouped,GroupBy(AddColumns(Filter(Transactions,'Transaction Type' = "Expense"),"Month",Text('Transaction Date',"[$-en-US]mmmm")),"Month","Transactions"));
Once I do that, my colTransactions collection is being manipulated and loses the value for some of the fields. E.g. "name" or "category"
See before and after:
Anyone knows why this is happening?
