Power Platform Community Forum Thread Details

Hello!

I am building a flow from Excel that takes information from a selected row and puts it into an approval request. Here is my flow thus far:

The flow is working fine, however, there are some values that are not populating in the approval request (I've tried both the formatted and unformatted selection):

For ease, here are those values from the Compose action...

...and the columns from the MS Excel table:

and the JSON from the first step:

Schema:

{
  "type": "object",
  "properties": {
    "rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "text": {
            "title": "Justification",
            "type": "string",
            "x-ms-dynamically-added": true,
            "description": "Please enter your input",
            "x-ms-content-hint": "TEXT"
          },
          "email": {
            "title": "HR Approver Email",
            "type": "string",
            "format": "email",
            "x-ms-dynamically-added": true,
            "description": "Please enter an e-mail address",
            "x-ms-content-hint": "EMAIL"
          },
          "entity": {
            "type": "object",
            "properties": {
              "Req ID_Formatted": {
                "title": "Req ID (Formatted)",
                "type": "string"
              },
              "Position Title_Formatted": {
                "title": "Position Title (Formatted)",
                "type": "string"
              },
              "Buyout 1 Type (STI, LTI, SIP, Other)_Formatted": {
                "title": "Buyout 1 Type (STI, LTI, SIP, Other) (Formatted)",
                "type": "string"
              },
              "Buyout 1 as $ Amt_Formatted": {
                "title": "Buyout 1 as $ Amt (Formatted)",
                "type": "string"
              },
              "Buyout 1 Effective Date_Formatted": {
                "title": "Buyout 1 Effective Date (Formatted)",
                "type": "string"
              },
              "Buyout 2 Type (STI, LTI, SIP, Other)_Formatted": {
                "title": "Buyout 2 Type (STI, LTI, SIP, Other) (Formatted)",
                "type": "string"
              },
              "Buyout 2 as $ Amt_Formatted": {
                "title": "Buyout 2 as $ Amt (Formatted)",
                "type": "string"
              },
              "Buyout 2 Effective Date_Formatted": {
                "title": "Buyout 2 Effective Date (Formatted)",
                "type": "string"
              },
              "Buyout 3 Type (STI, LTI, SIP, Other)_Formatted": {
                "title": "Buyout 3 Type (STI, LTI, SIP, Other) (Formatted)",
                "type": "string"
              },
              "Buyout 3 as $ Amt_Formatted": {
                "title": "Buyout 3 as $ Amt (Formatted)",
                "type": "string"
              },
              "Buyout 3 Effective Date_Formatted": {
                "title": "Buyout 3 Effective Date (Formatted)",
                "type": "string"
              },
              "Buyout 4 Type (STI, LTI, SIP, Other)_Formatted": {
                "title": "Buyout 4 Type (STI, LTI, SIP, Other) (Formatted)",
                "type": "string"
              },
              "Buyout 4 as $ Amt_Formatted": {
                "title": "Buyout 4 as $ Amt (Formatted)",
                "type": "string"
              },
              "Buyout 4 Effective Date_Formatted": {
                "title": "Buyout 4 Effective Date (Formatted)",
                "type": "string"
              },
              "Buyout 5 Type (STI, LTI, SIP, Other)_Formatted": {
                "title": "Buyout 5 Type (STI, LTI, SIP, Other) (Formatted)",
                "type": "string"
              },
              "Buyout 5 as $ Amt_Formatted": {
                "title": "Buyout 5 as $ Amt (Formatted)",
                "type": "string"
              },
              "Buyout 5 Effective Date_Formatted": {
                "title": "Buyout 5 Effective Date (Formatted)",
                "type": "string"
              },
              "Work Location_Formatted": {
                "title": "Work Location (Formatted)",
                "type": "string"
              },
              "Geography_Formatted": {
                "title": "Geography (Formatted)",
                "type": "string"
              },
              "Hiring Manager_Formatted": {
                "title": "Hiring Manager (Formatted)",
                "type": "string"
              },
              "New Grade_Formatted": {
                "title": "New Grade (Formatted)",
                "type": "string"
              },
              "Candidate Name_Formatted": {
                "title": "Candidate Name (Formatted)",
                "type": "string"
              },
              "Base Salary Level_Formatted": {
                "title": "Base Salary Level (Formatted)",
                "type": "string"
              },
              "Base Increase (Offer / Current Base) as %_Formatted": {
                "title": "Base Increase (Offer / Current Base) as % (Formatted)",
                "type": "string"
              },
              "Proposed Start Date_Formatted": {
                "title": "Proposed Start Date (Formatted)",
                "type": "string"
              },
              "Sign-on Bonus as $ Amt_Formatted": {
                "title": "Sign-on Bonus as $ Amt (Formatted)",
                "type": "string"
              },
              "Sign-on Bonus Effective Date_Formatted": {
                "title": "Sign-on Bonus Effective Date (Formatted)",
                "type": "string"
              },
              "Candidate Type_x003a_ Internal/External_Formatted": {
                "title": "Candidate Type: Internal/External (Formatted)",
                "type": "string"
              },
              "Offer_x003a_ Base Salary_Formatted": {
                "title": "Offer: Base Salary (Formatted)",
                "type": "string"
              },
              "Offer_x003a_ Target Total Direct Comp_Formatted": {
                "title": "Offer: Target Total Direct Comp (Formatted)",
                "type": "string"
              },
              "Offer Base_x003a_ Market Ratio_Formatted": {
                "title": "Offer Base: Market Ratio (Formatted)",
                "type": "string"
              }
            },
            "required": [
              "Req ID_Formatted",
              "Position Title_Formatted",
              "Buyout 1 Type (STI, LTI, SIP, Other)_Formatted",
              "Buyout 1 as $ Amt_Formatted",
              "Buyout 1 Effective Date_Formatted",
              "Buyout 2 Type (STI, LTI, SIP, Other)_Formatted",
              "Buyout 2 as $ Amt_Formatted",
              "Buyout 2 Effective Date_Formatted",
              "Buyout 3 Type (STI, LTI, SIP, Other)_Formatted",
              "Buyout 3 as $ Amt_Formatted",
              "Buyout 3 Effective Date_Formatted",
              "Buyout 4 Type (STI, LTI, SIP, Other)_Formatted",
              "Buyout 4 as $ Amt_Formatted",
              "Buyout 4 Effective Date_Formatted",
              "Buyout 5 Type (STI, LTI, SIP, Other)_Formatted",
              "Buyout 5 as $ Amt_Formatted",
              "Buyout 5 Effective Date_Formatted",
              "Work Location_Formatted",
              "Geography_Formatted",
              "Hiring Manager_Formatted",
              "New Grade_Formatted",
              "Candidate Name_Formatted",
              "Base Salary Level_Formatted",
              "Base Increase (Offer / Current Base) as %_Formatted",
              "Proposed Start Date_Formatted",
              "Sign-on Bonus as $ Amt_Formatted",
              "Sign-on Bonus Effective Date_Formatted"
            ]
          }
        },
        "required": [
          "entity"
        ]
      }
    }
  },
  "required": [
    "rows"
  ]
}

Outputs:

{
  "text": "He's nice",
  "email": "jessica.duffey@bayer.com",
  "entity": {
    "Req ID_Formatted": "111111",
    "Position Title_Formatted": "EXEC SALES CONSULTANT ONC",
    "Buyout 1 Type (STI, LTI, SIP, Other)_Formatted": "STI",
    "Buyout 1 as $ Amt_Formatted": "$60,000.00",
    "Buyout 1 Effective Date_Formatted": "4/1/2026",
    "Buyout 2 Type (STI, LTI, SIP, Other)_Formatted": "",
    "Buyout 2 as $ Amt_Formatted": "",
    "Buyout 2 Effective Date_Formatted": "",
    "Buyout 3 Type (STI, LTI, SIP, Other)_Formatted": "",
    "Buyout 3 as $ Amt_Formatted": "",
    "Buyout 3 Effective Date_Formatted": "",
    "Buyout 4 Type (STI, LTI, SIP, Other)_Formatted": "",
    "Buyout 4 as $ Amt_Formatted": "",
    "Buyout 4 Effective Date_Formatted": "",
    "Buyout 5 Type (STI, LTI, SIP, Other)_Formatted": "",
    "Buyout 5 as $ Amt_Formatted": "",
    "Buyout 5 Effective Date_Formatted": "",
    "Work Location_Formatted": "RESIDENCE",
    "Geography_Formatted": "Boston",
    "Hiring Manager_Formatted": "Paul Antogiovanni",
    "New Grade_Formatted": "VS1.2",
    "Candidate Name_Formatted": "John Michaelson",
    "Base Salary Level_Formatted": "DEVELOPMENTAL",
    "Base Increase (Offer / Current Base) as %_Formatted": "10%",
    "Proposed Start Date_Formatted": "1/1/2026",
    "Sign-on Bonus as $ Amt_Formatted": "$25,000",
    "Sign-on Bonus Effective Date_Formatted": "2/1/2026",
    "Candidate Type_x003a_ Internal/External_Formatted": "",
    "Offer_x003a_ Base Salary_Formatted": "",
    "Offer_x003a_ Target Total Direct Comp_Formatted": "",
    "Offer Base_x003a_ Market Ratio_Formatted": ""
  }
}
 
Any ideas on why these fields aren't populating?