Forum Discussion
KevinHemelrijk
Oct 26, 2023Copper Contributor
Watchlists: failed to resolve scalar expression
Hi Techies, We want to use a watchlist inside a KQL query which is supposed to be simple, but we are actually struggling a bit with the following issue "'project' operator: Failed to resolve scal...
- Oct 26, 2023Thats odd. Will any other Column project ok, such as SearchKey?
Maybe there are some control characters or spaces in the original CSV file, or it's corrupted in some way?
Clive_Watson
Oct 26, 2023Bronze Contributor
If you just query this, does it work? That error is usually the Column name not being found by project (and its case sensitive).
_GetWatchlist('VIPUsers') | project emailAddress
_GetWatchlist('VIPUsers') | project emailAddress
- KevinHemelrijkOct 26, 2023Copper Contributor
- Clive_WatsonOct 26, 2023Bronze ContributorNow try it without the project: _GetWatchlist('VIPUsers')
It seems like the Column is named something other than "emailAddresses"- KevinHemelrijkOct 26, 2023Copper Contributor