Unanswered

One Parent Record in SharePoint with Multiple Child Records in Secondary List, Get Children and Export as XML Into CSV File

(0) Share

Report

Posted on by cjwilson80

Hello!
We have a Parent List in a SharePoint Site with a secondary Child List in the same SharePoint Site. We are using a Flow to get the parent records with a status of "Accepted" and it's related children and exporting it to a .CSV file. The problem we are having is that the parent records with more than one related child record are not being added to the xml output. Only one child record is being exported as xml to the CSV and not all the child records. I should note that not all parent records will have more than one child record. So, for those items, the flow works. It gets the parent record and exports the related child records to XML just fine. The issue is if there is more than one child record.

How can we achieve this? PLEASE HELP! Thank you 🙂

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Can you provide a bit more info.
How are the two lists linked? Are you using a Lookup field for instance?
Are you able to show a screenshot of your two lists (sample data or obfuscated is fine)
Are you able to show what you currently have in your flow, and what the current output you are getting is?
How are you converting the JSON to XML?

Was this reply helpful? Yes No
cjwilson80 95 on at

Like (0)

Report

Hi @grantjenkins

The lists are linked by a Parent ID column using a lookup column. I've uploaded a GIF of the flow for your reference. What's happening is that we're getting all the child records associated with one parent record, but the child records or overwriting one another and we end up with only the last child record. So, if a parent record has 3 children, only the 3rd child record will be exported, etc.

Was this reply helpful? Yes No