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!!!
User | Count |
---|---|
24 | |
14 | |
4 | |
3 | |
3 |