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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jcwtecpe on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you paste the XML as text?

Was this reply helpful? Yes No
Verified answer

Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jcwtecpe on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No