I have a logic app which needs send the query result to given mail id. The issue is header columns contains like [data-01]. The logic app while sending the data it sends the csv like [data_x002d_01]. This is happening only in the columns. The values for the columns hyphens have no issues.
The csv sent to the email as below where you can see the hyphen is converted into x002d
How to avoid the conversion I want the column to be as like [vh-d]
CodePudding user response:
Created logic app as shown below,
In Execute SQL query action, selected required column as shown below,
Create CSV csv table action, selected column type as Custom
Added vh-d as Header column and value as output of sql query.
In send email action, added output of csv table as attachment.
Logic app ran successfully,
The attachment in mail has data as shown below,