Value Select can not break line in JSON APPSHEET

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!!!

0 1 108
1 REPLY 1

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.

Top Labels in this Space