Hi,
I write a Automation sent messenger to Telegram Bot. I have a problem when use Select and send to Telegram.
My formula in JSON body:
"parse_mode": "HTML",
"text": "<<Concatenate(SELECT(Seller[NameSeller], [TotalQuant] = 0),\n)>>"
Value return in Telegram bot:
John, Mike, Chester.
I want value return in Telegram bot is:
John
Mike
Chester
i was try use Concatenate(SELECT(Seller[NameSeller], [TotalQuant] = 0), \\n) or "\n"
or trySUBSTITUTE(SELECT(Seller[NameSeller], [TotalQuant] = 0),",",\n)
Thanks everyone!!!
Is "Telegram" an external service you are making an API call to? If so, do they support "\n" as the newline indicator?
In Appsheet, "\n" is NOT recognized as a newline character. Typically we would insert an actual line break. Maybe try this:
SUBSTITUTE(SELECT(Seller[NameSeller], [TotalQuant] = 0),
",",
" <<-The return key was inserted here
")
I don't know if there will work inside of JSON.
User | Count |
---|---|
15 | |
15 | |
8 | |
7 | |
4 |