Whatsapp Expression Suggession

[diyorapiyush]

Hi,

I have a table = "GST Whatsapp"

Column Name = "GST Amount"

I want the expression to extract the GST amount from the table and show it as,

For example, 

"Please transfer GST amount = 9000 to the following bank account......."

Below is the WhatsApp expression that I am using. Everything is working fine, except for GST Amount (shown as red in the given expression).

Below expression gives me this result,

"Please transfer GST amount = [GST Whatsapp[GST Amount]] to the following bank account......"

CONCATENATE(
"https://api.whatsapp.com/send?phone=+91",ENCODEURL(Any(Select(Database[Mobile],[_Thisrow].[Flat]=[Flat]))),
"&text=",ENCODEURL("Please transfer GST amount = [GST Whatsapp[GST Amount]] to the following bank account.

A/c No: 00000000

A/c Name: ABC

ISFC: ABC

Bank:ABC Bank

Branch: ABC"))

I would really appreciate if someone could help me with this

@Marc_Dillon @Steve @Suvrutt_Gurjar 

[Suvrutt_Gurjar]

You may want to address your query to all the community so that you will get the best possible and faster answer.

In your expression  [GST Whatsapp[GST Amount]]   is an incorrect syntax. 

Could you update where you are using this CONCATENATE() expression, meaning in another column, action or where and is the table where this expression is based different from the GST table?

[diyorapiyush · Accepted solution]

Hey guys, sorry for disturbing you. 

But after few changes I was able to solve the error

Here is the expression if you want to see or use.

CONCATENATE("https://api.whatsapp.com/send?phone=+91",

ENCODEURL(Any(Select(Database[Mobile],[_Thisrow].[Name]=[Name]))),

"&text=",

ENCODEURL("Please transfer GST amount = "),

ENCODEURL(Any(Select(GST Whatsapp[GST Amount],[_Thisrow].[Name]=[Name]))),

ENCODEURL(" to the following bank account.

A/c No: 0000

A/c Name: ABC

ISFC: ABC

Bank: ABC BANK

Branch: ABC"))

[Suvrutt_Gurjar]

Excellent! Great going.