I'm following this tutorial Link . In Step 4 it mentions the JSON format of Parameters in the Create Pipeline Run action but in my case I'm using STRING not OBJECT. Here's the whole contents of the FLOW
These are now the parameters I have in my Pipeline.
Here's the whole code I have for my parameter in Power Automate
{
"inputs": {
"variables": [
{
"name": "Database",
"type": "String",
"value": @{triggerBody()['text_1']}
},
{
"name": "CreateDate",
"type": "String",
"value": @{triggerBody()['text']}
},
{
"name": "RequirementId",
"type": "String",
"value": @{triggerBody()['text_2']}
},
{
"name": "PolicyNumber",
"type": "String",
"value": @{triggerBody()['text_3']}
},
{
"name": "StateOfIssue",
"type": "String",
"value": @{triggerBody()['text_4']}
},
{
"name": "RequirementStatus",
"type": "String",
"value": @{triggerBody()['text_5']}
},
{
"name": "CaseStatus",
"type": "String",
"value": @{triggerBody()['text_6']}
},
{
"name": "ParamType",
"type": "String",
"value": @{triggerBody()['text_7']}
},
{
"name": "SalesSource",
"type": "String",
"value": @{triggerBody()['text_8']}
},
{
"name": "UnderwritingPathCategory",
"type": "String",
"value": @{triggerBody()['text_9']}
}
]
}
}
When my Power Apps trigger the Power Automate flow, the Database and CreateDate has a value when I check the RUN HISTORY in Power Automate.
When I check the Monitor and Pipeline Run in Azure Data Factory these values are null. I created a variable in ADF named DBName then use an activity to set it to value of the Database Parameter sent by Power Automate.
I'm not sure If I missed something or if my JSON format in Create Pipeline run is correct? Really appreciate anyone who has some input about this. Thanks in advance!
