Pass Parameter to ADF V2 Pipeline from FLOW (Power Automate) in Common Data Service Connector

In a scenario, where we need to run any ADF pipeline using FLOW, which is having parameters in it and performs operations based on the passed value. Lets say, we have a scenario, whenever any operation is performed on D365 record (create/update), a FLOW is triggered and the record id is passed as a parameter to pipeline run action. Then, the ADF pipeline performs the intended operation with the passed record id. This is a simple process and can be achieved with connectors and actions in FLOW. This was working smoothly, but with the recent deprecation of Dynamics 365 connector, replacing it with CDS connector; resulted in failures and inability to save the FLOW. On save following error being thrown:

“Flow save failed with code ‘OpenApiOperationParameterValidationFailed ”

To fix this issue, the parameter needs to be parsed using Parse JSON Data Operation now. Follow the steps below:

  1. Add new Data Operation of type Parse JSON before “Create a pipeline run” action:
  2. In Content paste JSON with your parameter, like : {“param1”: “”}
  3. Put the entity from Dynamic Content:
  4. In Schema, click on Generate from sample and paste JSON in popup like: { “param1”: “MyValue”}. Once clicked on Done, pop up will close and Schema will look like this:
  5. Now, go to Create a pipeline run action and select parameters
  6. Select Body from the Dynamic content.
  7. Save your FLOW, and perform the triggering operation on D365.

Look at the pipeline runs and FLOW runs. Check the run id. FLOW run is having the same run id of pipeline. Your FLOW has been successfully run and so the pipeline…

Points to remember:

  • Use the same parameter name, which is defined in ADF Pipeline
  • Ensure the parameter name and dynamic value is within double quotes