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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Optimal way to replace specified elements and nodes from an XML file in Power Automate?

(2) ShareShare
ReportReport
Posted on by

Good morning, everyone,

 

I'm currently attempting to create a flow that allows me to parse a large amount of XML files that will share the same schema and transform them into more useful excel files. The issue that I'm encountering is that there are several nested child elements within the file that contain {"xsI:nil": "true"} values that I want removed, preferably in one action. I'm very new to XML files and syntax, so I will share an example of the XML file below:

 

Elijah6ixer_0-1692892232107.png

 

There are several books within the file and hundreds of these nil values sprinkled in between 11,000 rows of data. I need to create a flow/function that removes the entire {"@xsi:nil": "true"} value and replaces it with a null value for the conversion into excel to go smoothly. How can I achieve this and also append each book to its own array so that I may place the data within their own individual sheets on an excel file?

I have the same question (0)
  • rameshmukka Profile Picture
    1,110 on at
    Re: Optimal way to replace specified elements and nodes from an XML file in Power Automate?

    @Elijah6ixer 

    Surprised at not seeing any responses for this. Have you figured out any solution for this? I am also trying to replace certain values in my XML. Let me know if you found any solution.

     

    Thanks,

    Ramesh

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard