Trigger the HTML output using Logic App

Question

Trigger the HTML output using Logic App

Abrar Adil S 401

I have trigger a Azure API to retrieve the cost details, the output which has been provided I want to select the output and store it in a csv and send over an email, but unable to get the desired output.

Screenshot 2023-05-24 122806.png the Logic App workflow

Screenshot 2023-05-24 122905.png Output received through the email

Azure API : https://learn.microsoft.com/en-us/rest/api/cost-management/query/usage?tabs=HTTP#subscriptionquery-legacy

Screenshot 2023-05-24 123303.png body of the HTTP trigger

Accepted answer

0 additional answers

Your answer

Answer 1

VenkateshDodda-MSFT 24,951 Microsoft Employee Moderator

@Abrar Adil S Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

Based on above shared information, we have understood that you are trying to pull the usage report based on the resource type under a particular subscription using HTTP trigger and by creating a CSV table and post that sending the table as .csv file as an attachment in the email.

To reproduce this behavior, we have created a consumption logic app with the below set of actions and triggers.

User's image

Here is the sample output for your reference:

enter image description here

Below are the expressions that we have used in Compose action and Create CSV Table action in our workflow.

Compose action:

"@body('Parse_JSON')?['properties']?['rows']"

Create CSV table :

PreTaxCost: @item()?[0]
BillingMonth: @item()?[1]
ResourceType:@item()?[2]
Currency:@item()?[3]

For more information, you can refer to this documentation, on how customize your CSV table in logic apps.
Feel free to reach back to me if you have any further questions on this.

Abrar Adil S 401 Reputation points

2023-05-24T10:37:08.82+00:00

@VenkateshDodda-MSFT Thanks so much for your help, however one correction in the output, can we modify the output file, BillingMonth, ResourceType, PreTaxCost, Currency, I tried changing it in the custom column, but the values are not changed.
Abrar Adil S 401 Reputation points

2023-05-24T10:55:51.4466667+00:00

@VenkateshDodda-MSFT Thanks so much for your help, however one correction in the output, can we get the output as BillingMonth, ResourceType, PreTaxCost and currency, I tried to change the headers in the CSV table, but was not able to get the desired output only the column name changed the data remained same,
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-05-24T11:01:02.9933333+00:00
@Abrar Adil S Thanks for your response. You need to change the above CSV table expression to the below to change the format of the table.

BillingMonth :@item()?[1] ResourceType : @item()?[2] PreTaxCost : @item()?[0] Currency : @item()?[3]

Share via

Trigger the HTML output using Logic App

0 additional answers

Your answer