Hi @Shafdev ,
You could try the following flow. It required a few more actions than I was expecting:
<info>
<user name="user1" age="21"/>
<user name="user2" age="22"/>
<user name="user3" age="23"/>
<user name="user4" age="24"/>
</info>
xml(outputs('Compose'))
From:
xpath(outputs('Compose_XML'),'/info/user/@name')
Map:
replace(replace(item(), 'name="',''), '"','')
From:
xpath(outputs('Compose_XML'), '/info/user/@age')
Map:
replace(replace(item(), 'age="',''), '"','')
From:
range(0, length(body('Select_Name')))
name:
body('Select_Name')?[item()]
age:
body('Select_Age')?[item()]
This is the runtime output:
When I used XPath to extract the name and age attributes (in steps 3 and 4) , Power Automate returned the attribute along with the values in this format, which wasn't what I was expecting:
[
"name=\"user1\"",
"name=\"user2\"",
"name=\"user3\"",
"name=\"user4\""
]
So, after extracting the data using XPath, I used some expressions to manipulate the string and extract just the value part:
[
"user1",
"user2",
"user3",
"user4"
]
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
