Issue with connected field of a lookup column.

- We have two SharePoint lists, A & B.

- In list A we have 1- a lookup column (L-column A) and 2- another connected lookup column in date format (C-column B). Both columns are coming from list B.

- Within list A, we tried a JSON formatting with a test on C-column B coming from list B. We get the value of L-column A with no issue. But we don't get the value of the connected field C-column B. We get no value, no errors, no nothing.