Unable to find table 'Table A', did you mean 'Table A'?

Hello Everyone, 

I am trying to use a FILTER( ) expression in a VC of type "List"

The VC is being created in:
Table B

The Expression: 

FILTER("Table A",[TRUCK REF] = [_THISROW].[TRUCK REF])

The Error:
Unable to find table 'Table A', did you mean 'Table A'

What is causing this error ? am sure that the table name is 100% as it is in the data tab and the data explorer

Would be highly appreciated if you can spot what i am doing wrong here

Table A is a Query table, set as read only

Thanks in advance

Solved Solved
0 1 248
1 ACCEPTED SOLUTION

The reason was the tab name in sheets has a # symbol in the naming

View solution in original post

1 REPLY 1

The reason was the tab name in sheets has a # symbol in the naming

Top Labels in this Space