Add XLM element in For Each Loop

(0) Share

Report

Posted on by dinnuk

Hi!

I am building a flow which should add an XML element for each record.

Something like:

</productionorder>

</productionorder>

</productionorder>

</productionorder>

</productionorder>

</productionorders>

</ERPSystem>

The XML-element Reference Number is non-existing in the XML i start with, and i would like to add this element to every productionorder (to fill it with an value)

However, i am struggeling to formulate the Xpath in the loop..

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

dinnuk 10 on at

Like (0)

Report

I i try it like on the screenshot above, the XML elements are added, but are all added to the first productionorder, hehe

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

This video will help you achieve the task of inserting the new element.

Was this reply helpful? Yes No
dinnuk 10 on at

Like (0)

Report

Hi!

Thank for the suggestion, indeed that video helped me along the way at first. The main problem is however the loop part.

If I place the add element outside the loop, then only the first production order gets the new element, I I place it within a loop, then the first productionorder gets ALL the new elements (so if the loop is for 60 productionorders, the first production order gets 60 similar elements ...)

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (0)

Report
That's a good challenge.

This is what you need.

The PAD script which you can paste in a new Flow editor and test the results

XML.ReadFromFile File: $'''C:\\Test\\Add XML element\\Books.xml''' Encoding: XML.FileEncoding.DefaultEncoding XmlDocument=> XmlDocument SET NodeCounter TO 1 LOOP WHILE (NodeCounter) <= (10) XML.InsertElement Document: XmlDocument XPathQuery: $'''ERPSystem/productionorders/productionorder[%NodeCounter%]''' Element: $'''<NewElement>Value Here%NodeCounter%</NewElement>''' ON ERROR GOTO LabelToContinue END Variables.IncreaseVariable Value: NodeCounter IncrementValue: 1 END LABEL LabelToContinue # COMMENT: do the rest of the saving actions here.

Notes:

- Even better error handling can be done by pin pointing to the exact error that line no. 4 throws.

- Make sure to change the xml path

- After line no. 7 do the usual thing as explained in the video

- I have given dummy values. Add your own values for the new elements.

Output after running the process

Was this reply helpful? Yes No
dinnuk 10 on at

Like (0)

Report

Wow. That worked flawless. Thank you!

Was this reply helpful? Yes No
dinnuk 10 on at

Like (0)

Report

Hi @VJR

One more question. It seems that the software where I import the XML expects a specific location for the Element.
Could I instruct Power Automate to place the new element on the second position within the Productionorder?
And not at the bottom?

Tnx

Was this reply helpful? Yes No