The issue only occurs in the Kubernetes runtime and cannot be reproduced in the Windows Preview environment. Using Count() on a multi-select field inside a where clause results in an invalid cast exception, while the same expression works correctly with a single-select field.
Count()
where
The page contains two panels with similar expressions. The first panel uses a single-select field, while the second uses a multi-select field.
1. Click the "Click here" button in the first panel (single-select). The expression executes successfully and displays the expected result.
2. Click the "Click here" button in the second panel (multi-select). The application returns an 500 Internal Server Error.
Single Select
Expression used: COUNT([Test] WHERE COUNT([Test.SingleSelect])=1)
Multi Select
Expression used: COUNT([Test] WHERE COUNT([Test.MultiSelect])=1)