Answered

Create SP items from XML. Apply to each: creates duplicated SP entries

(0) Share

Report

Posted on by jcwtecpe

Hello,

I am trying to parse and XML and create SP entries for each node information.

I think am doing the correct thing, however in the last step (Sharepoint item creation) it seems that that action is creating extra entries in the sharepoint. For example: I've 2 products in my XML; A and B. I want to create one entry for each product on SharePoint. However the results are:

-1 entry for A

-2 for B (one A and B)

It seems that its always creating again the previous item.

First item result:

Second item:

Any idea??

thanks!

All responses (5)

Answers (1)

jcwtecpe on at

Like (0)

Report

Re: Create SP items from XML. Apply to each: creates duplicated SP entries

I'm a very begginer in power automete so there are things I am not aware of 😅.
That worked! thank you!
Verified answer

Chriddle 7,793 Super User 2025 Season 1 on at

Like (0)

Report

Re: Create SP items from XML. Apply to each: creates duplicated SP entries

And you know that the function json() can convert XML to JSON?

The method described in the post looks a little overcomplicated 😁

In his post he does not nest the loops, you do.

That's why you get more entries as expected.

But anyhow, don't do it this way.

Convert the XML using the json() function and save yourself array variable and xpath expessions
Chriddle 7,793 Super User 2025 Season 1 on at

Like (0)

Report

Re: Create SP items from XML. Apply to each: creates duplicated SP entries

Can you paste the XML as text?
jcwtecpe on at

Like (0)

Report

Re: Create SP items from XML. Apply to each: creates duplicated SP entries

Sure;
Here is the XML im using:
So for each Matnr under zcds_md15type I'd like to have a new entry on SP. So for this i am creating an array varible that have some of the information I want to paste in the SP item

I've followed this post:

https://www.spguides.com/convert-xml-to-sharepoint-list-using-power-automate/

But I don't a relationship in the error I have.
Chriddle 7,793 Super User 2025 Season 1 on at

Like (0)

Report

Re: Create SP items from XML. Apply to each: creates duplicated SP entries

Maybe you should show us the XML and/or some details of your flow 😉