How to connect and pass parameter from Power Automate to the ADF pipeline

This manual is designed to guide you through setting up and passing parameter(s) from the Power Automate flow to the ADF pipeline, enabling you to manage your data operations efficiently.

A few assumptions that I made are:

1. The user has knowledge and experience with Power Automate.
2. The user has a working ADF environment.
3. The account used to create Power Automate can access the ADF environment where the pipeline is created.

Step 1: Call the Power Automate flow from the Power App ( not covered)

Step 2: Create the pipeline in the ADF environment by accepting the parameters that Flow will pass from Step 1.

• Add a new parameter in the pipeline with the type of Object.
• Add Activity: Set Variable

• ? Add a new variable as a type of string

• Set the variable by passing the parameter from the pipeline

• Add any other activities that are needed for your specific pipeline ( not covered here)
• Push the pipeline into live mode. The flow will only see it if it is in live mode!

Step 3: Create Flow in the Power Automate

• Go to Power Automate and create a new flow
• Select Create a pipeline run and select your newly created pipeline.

• In the parameter, you will have to pass it as JSON. Use JSON() in Power automate
• Please make sure the key has the same name as the parameters you set up in the ADF.
• If you need more than one parameter to receive from Power Automate, repeat this process X number of times.
• If you need to wait for the pipeline to finish running, add this code after you create a pipeline run.

Step 4: Run the test

Few notes:

• If you don't see your pipeline in the Power Automate, you have not published it into live mode.
• If you are triggering the ADF, but the value is not coming across, you are not passing the correct variable. Check your naming for parameters in the ADF and the flow.