Power Platform Community Forum Thread Details

Hello,

I have A flow which gets information from

https://api.exchangerate.host/latest

{"motd":{"msg":"If you or your company use this project or like what we doing, please consider backing us so we can continue maintaining and evolving this project.","url":"https://exchangerate.host/#/donate"},"success":true,"base":"EUR","date":"2022-12-14","rates":{"AED":3.901861,"AFN":91.367382,"ALL":114.819508,"AMD":416.419952,"ANG":1.914485,"AOA":536.38362,"ARS":182.461582,"AUD":1.553939,"AWG":1.914491,"AZN":1.806533,"BAM":1.971178,"BBD":2.124505,"BDT":109.170655,"BGN":1.955169,"BHD":0.401309,"BIF":2179.717092,"BMD":1.062852,"BND":1.439398,"BOB":7.354491,"BRL":5.623693,"BSD":1.0626,"BTC":0.00006,"BTN":87.747151,"BWP":13.701874,"BYN":2.680894,"BZD":2.141481,"CAD":1.441424,"CDF":2173.474008,"CHF":0.986934,"CLF":0.033187,"CLP":910.577371,"CNH":7.397146,"CNY":7.393475,"COP":5107.324294,"CRC":619.754024,"CUC":1.062668,"CUP":27.350543,"CVE":111.141708,"CZK":24.283541,"DJF":187.338221,"DKK":7.435831,"DOP":58.695269,"DZD":146.201452,"EGP":26.161525,"ERN":15.932229,"ETB":56.801314,"EUR":1,"FJD":2.323667,"FKP":0.860428,"GBP":0.860212,"GEL":2.82011,"GGP":0.859762,"GHS":13.86143,"GIP":0.86051,"GMD":65.747486,"GNF":9216.600147,"GTQ":8.376333,"GYD":222.180105,"HKD":8.259367,"HNL":25.974941,"HRK":7.535869,"HTG":153.455333,"HUF":410.722229,"IDR":16607.642932,"ILS":3.611026,"IMP":0.860344,"INR":87.755593,"IQD":1535.753847,"IRR":43972.803233,"ISK":150.719563,"JEP":0.859815,"JMD":163.543167,"JOD":0.753942,"JPY":143.883755,"KES":130.591609,"KGS":90.229613,"KHR":4347.580007,"KMF":492.649351,"KPW":955.930514,"KRW":1376.057773,"KWD":0.326674,"KYD":0.88477,"KZT":498.541769,"LAK":18234.384478,"LBP":1591.026887,"LKR":390.27164,"LRD":163.809913,"LSL":18.569415,"LYD":5.144595,"MAD":11.098783,"MDL":20.499496,"MGA":4688.933867,"MKD":61.50152,"MMK":2230.122067,"MNT":3618.691559,"MOP":8.511042,"MRU":39.981314,"MUR":46.373577,"MVR":16.35704,"MWK":1090.082638,"MXN":20.774223,"MYR":4.689857,"MZN":67.818984,"NAD":18.333559,"NGN":472.984366,"NIO":38.775819,"NOK":10.400507,"NPR":140.393609,"NZD":1.648522,"OMR":0.409049,"PAB":1.062802,"PEN":4.071406,"PGK":3.742548,"PHP":59.18321,"PKR":238.900222,"PLN":4.697545,"PYG":7552.594141,"QAR":3.862649,"RON":4.924304,"RSD":117.260454,"RUB":67.356983,"RWF":1126.429903,"SAR":3.993728,"SBD":8.742096,"SCR":14.305101,"SDG":602.768075,"SEK":10.868007,"SGD":1.433002,"SHP":0.860316,"SLL":18762.791867,"SOS":598.258167,"SRD":33.931609,"SSP":138.355701,"STD":24242.387648,"STN":24.470425,"SVC":9.290297,"SYP":2668.671466,"SZL":18.569642,"THB":36.739007,"TJS":10.67531,"TMT":3.691729,"TND":3.368502,"TOP":2.490318,"TRY":19.800687,"TTD":7.206014,"TWD":32.441979,"TZS":2479.046591,"UAH":39.031342,"UGX":3923.918724,"USD":1.062669,"UYU":41.239905,"UZS":11987.237569,"VES":14.974179,"VND":24965.24158,"VUV":125.379539,"WST":2.866222,"XAF":655.630623,"XAG":0.045757,"XAU":0.001103,"XCD":2.870794,"XDR":0.799717,"XOF":655.630008,"XPD":0.001953,"XPF":119.273033,"XPT":0.001216,"YER":265.801844,"ZAR":18.339629,"ZMW":18.590585,"ZWL":342.010648}}

How I can get all currencies names list(AED,AFN,ALL, etc) and store this names into a SP list or collection?

Categories:

Building flows

The easiest/quickest way is to convert the JSON data to XML then use XPath to extract the rates into an array.

See full flow below. I'll go into each of the actions.

HTTP is the same as what you have to retrieve the raw data.

XML is a Compose that converts your JSON data to XML. Note that it also adds a root node so it's valid XML. The expression used is below. You would pass in the body from your HTTP request.

xml(json(concat('{"root": ', body('HTTP'), '}')))

Select extracts out the rates into an array. The expressions used are below. Note that I've used text mode for the Map (see arrow in screenshot).

//input (FROM)
xpath(outputs('XML'), '//root/rates/*')

//Map
xpath(item(), 'name(//*)')

This would give us the following result:

To get these into your SharePoint list you can just use an Appy to each using the body of the Select as input, and a Create item action.

Community site session details

Get currencies names from HTTP request

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates