Teams message trigger - cannot provide numbers to lookup string

Question

Teams message trigger - cannot provide numbers to lookup string

Wiszowaty, Sebastian 25

Feb 15, 2024, 11:38 AM

When a number is included in the trigger string, the schema becomes invalid, resulting in a syntax error. Does this mean that the string trigger only supports letters? Why is this the case?

Syntax error: character '1' is not valid at position ...

  "queries": { "$search": "test123" }

JimmyYang-MSFT 58,561 Reputation points Microsoft External Staff

Feb 16, 2024, 1:39 AM

Hi @Wiszowaty, Sebastian Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. According to your description, your question is not in our support scope, so I will also add teams development tag to your thread. Thanks for your understanding!
farri65 5 Reputation points

Feb 20, 2024, 12:01 PM
In JSON syntax, the issue you're encountering is likely due to the fact that the dollar sign ('$') in "$search" is reserved for special keywords in certain contexts, such as MongoDB queries or Azure Search. In your example:

"queries": { "$search": "test123" }

The dollar sign preceding "search" suggests that this might be part of a query language where "$search" has a specific meaning. If this is not the intended use and you're merely trying to include a string, you might want to remove the dollar sign:

"queries": { "search": "test123" }

This modification adheres to standard JSON syntax. If the dollar sign is indeed required for a specific query language, you should consult the documentation for that language to understand the correct usage and how to include numbers or other characters within the string triggers. In JSON itself, strings can include letters, numbers, and other characters without issue. The challenge here is likely tied to the specific context or query language you are working with. Feel free to provide more context or specific details for a more tailored explanation! #JSON #QueryLanguage #SyntaxError 🚀 if your pet lover then also read the pet ethics
Wiszowaty, Sebastian 25 Reputation points

Feb 20, 2024, 12:05 PM

Hey @farri65 that would explain it, I haven't tested whether the search in the teams message would work without that dollar sign, as I just went and changed my searchwords to not include numbers. I might try it out when I have a change but I don't have any task that involves playing around with that :).