Editéieren

Deelen iwwer

Use the If Condition activity to execute activities based on an expression

The If Condition activity in Data Factory for Microsoft Fabric provides the same functionality that an if statement provides in programming languages. It executes a set of activities when the condition evaluates to true and another set of activities when the condition evaluates to false.

Prerequisites

To get started, you must complete the following prerequisites:

Add an If Condition activity to a pipeline with UI

To use an If Condition activity in a pipeline, complete the following steps:

Creating the activity

  1. Create a new pipeline in your workspace.

  2. Search for If Condition in the pipeline Activities pane, and select it to add it to the pipeline canvas.

    Screenshot of the Fabric UI with the Activities pane and If Condition activity highlighted.

  3. Select the new If Condition activity on the canvas if it isn't already selected.

    Screenshot showing the General settings tab of the If Condition activity.

Refer to the General settings guidance to configure the General settings tab.

If Condition settings

Select the Activities tab and provide a dynamic boolean Expression for the If activity. In this simple example, we randomly generate a number between 0 and 1, and return True if the number is greater than or equal to .5, or otherwise False. You can use any of the available functions in the Data Factory expression language or any parameters specified in the pipeline.

After providing the expression for the If Condition, selecting the pencil icon beside each case (True/False) allows you to add as many activities as necessary to be conditionally executed whenever the expression evaluates.

Screenshot showing the If Condition Activity settings tab and showing where to provide the Expression and choose Activities for when the expression evaluates to True or False.

Tip

For more examples and information about the expression language, see: Expressions and functions for Data Factory in Microsoft Fabric

Save and run or schedule the pipeline

Switch to the Home tab at the top of the pipeline editor and select the save button to save your pipeline. Select Run to run it directly or Schedule to schedule runs at specific times or intervals. For more information on pipeline runs, see: schedule pipeline runs.

Screenshot showing the Home tab in the pipeline editor with the tab name, Save, Run, and Schedule buttons highlighted.

After running, you can monitor the pipeline execution and view run history from the Output tab below the canvas.

Related content

  • Last updated on