Home > front end >  Azure logic app converts hyphen-minus to _x002d_
Azure logic app converts hyphen-minus to _x002d_

Time:11-08

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.

enter image description here

The csv sent to the email as below where you can see the hyphen is converted into x002d

enter image description here

How to avoid the conversion I want the column to be as like [vh-d]

CodePudding user response:

  1. Created logic app as shown below, enter image description here

  2. In Execute SQL query action, selected required column as shown below, enter image description here

  3. Create CSV csv table action, selected column type as Custom

  4. Added vh-d as Header column and value as output of sql query. enter image description here

  5. In send email action, added output of csv table as attachment. enter image description here

  6. Logic app ran successfully, enter image description here

  7. The attachment in mail has data as shown below, enter image description here

  • Related