Power Platform Community Forum Thread Details

Hi Experts, I would be grateful if someone could help me with this. I have made a flow that converts xml to Json string. Flow output is stored in after trated with ParseJSON function in ParsedData(untyped Object data type). Using Clearcollect function I have created a table called Profile from ParsedData, I have made some changes in Profile collection using Patch function. Now I'm tring to Update the Profile details in ParsedData, Please help me with your valuable suggestions to update the ParsedData collection.
ParsedData is having more fields other than Profile. Thankyou.

"employer": {
      "@profileCount": "1",
      "@valid": "true",
      "ownershipVerification": {
        "@ownerCount": "1",
        "@valid": "true",
        "owner": {
          "@valid": "true",
          "isFromRecords": "true",
          "person": {
            "@valid": "true",
            "zipCode": "23233",
            "state": "VA",
            "ssn": "678-67-8767",
            "country": "USA",
            "telephone": "881-881-8810",
            "city": "RICHMOND",
            "addressLine1": "123 CHERRY HILL RD",
            "title": {
              "@valid": "true",
              "label": "Vice-President",
              "type": "titleResponsibleParty",
              "code": "VP"
            },
            "firstName": "Mike",
            "lastName": "Miller",
            "middle": ""
          }
        }
      },
      "profile": {
        "@valid": "true",
        "qualificationType": "Regular",
        "employerName": "LEGAL NAME",
        "type": "Current",
        "address": {
          "@valid": "true",
          "line2": "",
          "line1": "145 S Cherry St",
          "zip": "23235",
          "state": "VA",
          "city": "Richmond"
        },
        "liabilityDate": "2023-01-01",
        "firstEmploymentDate": "2023-01-01",
        "primaryDBA": "TRADING AS NAME",
        "businessActivity": "Ball and roller bearing manufacturing",
        "liabilityType": "C",
        "status": "Active",
        "entityType": "Corporation",
        "telephone": "8047788845",
        "statusEffectiveDate": "2023-01-01",
        "numberOfLocations": "1"
      }
    },

Categories:

Building Power Apps

Hi CU23011338-0

To update the ParsedData collection, you need to use the Patch function again to update the profile field within ParsedData

// Step 1: Modify the Profile collection (this part is already done in your flow)

ClearCollect(Profile, ParsedData.profile); // Assuming ParsedData.profile is the profile part of your JSON

// Step 2: Update the profile data within ParsedData

Patch(

    ParsedData,

    LookUp(ParsedData, true), // Look up the correct record in ParsedData

    {

        employer: ParsedData.employer, // Keep the other fields the same

        profile: LookUp(Profile, true) // Update the profile field with the modified data from Profile collection

    }

);

pls try and let me know how if you need more details.

thanks