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

Notifications

Announcements

Community site session details

Community site session details

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

XML to JSON Conversion

(0) ShareShare
ReportReport
Posted on by 173

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,189 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
    173 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,189 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard