Skip to main content

Notifications

Power Automate - Using Flows
Answered

Data loss when working with Parent-Child response data

(0) ShareShare
ReportReport
Posted on by 4
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!
 
  • GM-31071618-0 Profile Picture
    GM-31071618-0 4 on at
    Data loss when working with Parent-Child response data
    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.
  • Verified answer
    Gopala_Krishna Profile Picture
    Gopala_Krishna 1,459 on at
    Data loss when working with Parent-Child response data
    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
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics

Restore a deleted flow