web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Data loss when working...
Power Automate
Answered

Data loss when working with Parent-Child response data

(0) ShareShare
ReportReport
Posted on by 20
I'm not sure if this is a power automate issue or a power app one, you all let me know.
I need some help understanding why some of my data is going missing.  I have an app that runs a Parent-Child flow on startup. The flows work fine and are intended to populate a gallery with the end users submitted requests. The parent only takes the user name and passes it to the child, then the child flow accesses an HR library to get that user’s file properties, runs a select to narrow the response to the necessary elements, and then responds to the parent with the select output as a string. The OnStart call then puts the response in a variable, and I can confirm that all the data that should be there is all there.
In order to have the data as a data source for a gallery, I then need to put the data into a collection. To achieve this, I parse the response, typecast each returned value, and put the values in a Table. As there will always be more than one file returned, this is done in a ForAll block. Then I put the Table in a collection. Now when I look at the content of the Collection, some of the data is missing. For example, DocType shows no data in the collection. DocType is a choice column, and there are three types of documents that may be selected. This is critical because the gallery needs to filter on DocType = “Request”.  Data from other choice type columns is included in the flow response and ends up being properly reflected in the Collection. What could be causing some data to be dropped between the variable and the collection?
Is there something unique I need to do on the power automate side to make sure the data doesn't get lost?  Thanks in advance for any insights!
 
Categories:
I have the same question (0)
  • Verified answer
    Gopala_Krishna Profile Picture
    1,495 on at
    As indicated in the images I notice that you are trying to reference the DocType incorrectly
     
    Reference to Image 1 column name is referred as "DocType"
     
    Reference to Image 2 column name is mentioned as "DocType" but the reference structure is mentioned as ThisRecord.Value.Doctype instead of ThisRecord.Value.DocType.
     
    At both the places T should be in caps when referring to DocType.
     
    Also I would suggest to considering using With function inside ForAll to ease the reference of record
     
     
  • GM-31071618-0 Profile Picture
    20 on at
    Thank you for you quick and helpful response. I am embarrassed to say I made such a simple mistake and let it hold me up so long. I'll look into With. Thanks again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 315 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 273 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 117 Super User 2026 Season 1

Last 30 days Overall leaderboard