List not showing a list

Rod
Bronze 3
Bronze 3

I have a virtual column with this expression to show a list result:

SELECT(Trips[ID],
AND(
([Driver]=[_THISROW].[Driver]),
([Date]>=[_THISROW].[Start Date]),
([Date]<=[_THISROW].[End Date]
)))

I've used this in other apps and it works great but for some reason in this app it's not showing the entire list. The result is this:

Rod_0-1658356336170.png

Then I get an error in a report that I'm generating to send out that says it's not a list. 

So the question is, what am I doing wrong? Where should I look for errors? 

Thanks!

0 3 125
3 REPLIES 3

What is the col definition of Trips?

Since you are retrieving IDs, I would assume it needs to be NOT text, but of a List with Ref to Trips?

The Trips column def is List which the app auto detects when the expression is saved...I think..

Rod
Bronze 3
Bronze 3

It's working now. Frustrating, finally removed the table, reinstalled it used the same expressions and now all of the columns are showing up. 

Top Labels in this Space