Need help with HTTP call and splitting the result

[StephenM]

hi - i have a HTTP call to get data for exchange rates. and currently it sends the body to me as an email. 

i want to pull out jus the exchange rates such as

1 GBP = 1.42249821 USD

1 GBP = 1.14345237 EUR

1 GBP = 1.32557023 CHF

can someone please help me pull just that piece out.

thanks

here's some screens to show you what i have so far

[v-micsh-msft]

Hi @StephenM,

Please take a try with the steps below:

1. After your HTTP action, add an Initialize variable action, choose the type to Array, Name it to Rate, and just leave the value part blank,

2. Add an Apply to each action, under the Input part of the Apply to each, enter the following expression:

split(last(split(body('HTTP'),'</lastBuildDate>')),'</title>')

The expression above would split the whole HTML into 149 items,

Image reference:

3. Within the Apply to each, add a Append to Array Variable action, under the Name, choose Rate, Value part enter the following expression:

last(split(items('Apply_to_each'),'<title>'))

This would return the "1 GBP = 1.42249821 USD" part you wanted from each items seperated under Step 2, then we will add it into the Rate Array,

4. Outside the Apply to each, now the Array should contain all the needed information, but with the last elements not right, so we need to remove the last item of the Array, with the expression below :

take(variables('Rate'),sub(length(variables('Rate')),1))

5. Add a Select Action, under the From part, enter the Expression mentioned in step 4, under the map part, enter string "Rate", and the other part, enter expression

item()

6. After that, add Create HTML table action, use the Select output as the value input, then add the Send Email Action, set Is HTML to YES, and body to the output of HTML table Action.

7. Click save, and the results under the Email should be as below:

Regards,

Michael