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

(2) Share

Report

Posted on by Elijah6ixer

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:

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)

All responses (1)

Answers (0)

rameshmukka 1,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No