web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / XML to JSON Conversion
Power Automate
Answered

XML to JSON Conversion

(0) ShareShare
ReportReport
Posted on by 181

HI,

 

I am trying to decode a SOAP message and bring the data back to a Power App. I have managed to get the data from the webservice, and decoded the answer with decodeBase64. But I think I need to get rid of some unneccessary data, and I don't know how to do this. 

The actual result look like this:
<?xml version="1.0" encoding="iso-8859-1"?><result>
<row index="1">
<NAMN index="0">Innovatum Portfolio AB</NAMN>
<ORGNR index="0">556546-1992</ORGNR>
</row>
<row index="2">
<NAMN index="0">Innovatum AB</NAMN>
<ORGNR index="0">556546-2008</ORGNR>
</row>
<row index="3">
<NAMN index="0">Innovatum Science Center AB</NAMN>
<ORGNR index="0">556556-7301</ORGNR>
</row>
<row index="4">
<NAMN index="0">Innovatum Progress AB</NAMN>
<ORGNR index="0">556887-6592</ORGNR>
</row>
<row index="5">
<NAMN index="0">Stiftelsen Innovatum</NAMN>
<ORGNR index="0">863001-1057</ORGNR>
</row>
</result>

What I want is just the NAMN and ORGNR for each row. Does anyone have any ideas?

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,918 Most Valuable Professional on at

    Hi @LennartWalldén,

     

    You could use an xpath function for that. In what format do you want the results? 

     

    Below is an example of how you could use xpath.

     

    xpath(xml(outputs('Compose')), '/result/row/NAMN | /result/row/ORGNR')

     

    xpath_example.png

     

    With this setup the result will look like below.

     

     

    xpath_example02.png

  • LennartWalldén Profile Picture
    181 on at

     Hi @Expiscornovus,

     

    Thanks for the reply.
    Looks good, but I also would like to get rid of all the indexes and only keep the value. Is that possible?

    I would like the result as an array in JSON format so I can read it back to my PowerApp via an array variable.

  • Verified answer
    Expiscornovus Profile Picture
    33,918 Most Valuable Professional on at

    Hi @LennartWalldén,

     

    If you want JSON format we can use the json function. We probably don't need xpath in that case.

     

    In the From field of the Select action I am using this expression

     

    json(xml(outputs('Compose')))['result']['row']

     

     

    In the Map field I am using the following expression for the value fields:

     

    item()?['NAMN']['#text']
    item()?['ORGNR']['#text']

     

    noxpathneeded.png

     

    That should give you an output format like below. Hopefully that is what you are looking for?

     

    noxpathneeded02.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 223

#2
David_MA Profile Picture

David_MA 210 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 175

Last 30 days Overall leaderboard