I’ve one complex problem in Power Automate. Please HELP!!

I’m using two tables ‘new_demotable001’ and ‘new_metadatatable’. One to trigger the flow and another as Mapping Sheet, respectively.

By using both I want to create a JSON payload that I’ll use to call external API. Please help me create the payload.

<Details/Prerquisite>

1. When a new row added in new_demotable001, flow triggers.
2. The data/attributes we will receive from table are – Note: I’ve removed unnecessary attributes.

{
  "statecode": 0,
  "_statecode_label": "Active",
  "statuscode": 1,
  "_statuscode_label": "Active",
  "new_empstatus": 100000001,
  "new_empname": "EmpName909",
  "new_empcontact": "9090990909090909",
  "new_empexperience": "100000000,100000001,100000002"
}

3. Then fetch details from ‘new_metadatatable’ table using “List Rows”.
4. The data/attributes we will receive from table are – Note: I’ve removed unnecessary attributes.

{
  "@Microsoft.Dynamics.CRM.totalrecordcount": -1,
  "@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded": false,
  "@Microsoft.Dynamics.CRM.globalmetadataversion": "11353407",
  "value": [
    {
      "new_sirionattributetype": "TEXT",
      "new_sirionattributename": "title",
      "new_dynamicsattributename": "new_empname"
    },
    {
      "new_sirionattributetype": "NUMERIC",
      "new_sirionattributename": "test1",
      "new_dynamicsattributename": "new_empcontact"
    },
    {
      "new_sirionattributetype": "SINGLE_REF",
      "new_sirionattributename": "orgId",
      "new_dynamicsattributename": "new_empstatus"
    },
    {
      "new_sirionattributetype": "MULTI_REF",
      "new_sirionattributename": "sirionExp",
      "new_dynamicsattributename": "new_empexperience"
    }
  ]
}

5. Now, I want to create a JSON payload using above attributes. To create payload we will use only those attributes which are present in ‘new_metadatatable’ and also coming from ‘new_demotable001’. -> The Condition I used – contains(triggerOutputs()?[‘body’], items(‘Apply_to_each’)?[‘new_dynamicsattributename’])

6. ‘new_sirionattributetype’ attribute value defines the structure of Expected Output Payload.
   If ‘new_sirionattributetype’ is TEXT/NUMERIC Output Payload will be normal JSON, if it is SINGLE_REF then Output Payload will have object {}, if it is MULTI_REF then Output Payload will have array object [].

7. For above set of data, the expected output payload should be-

{
    "data": {
        "orgId": {
            "id": 100000001
        },
        "test1": "9090990909090909",
        "title": "EmpName909",
        "sirionExp": [
            {
                "id": 100000000
            },
            {
                "id": 100000001
            },
            {
                "id": 100000002
            }
        ]
    }
}

Please help me with this complex problem.

Also suggest, if this can be acheived by any other method like using script or something.