Relate or unrelate rows in Dataverse

Important

You can associate two Dataverse rows only if they have a one-to-many or many-to-many relationship.

Relate rows

Follow these steps to associate two rows while editing your flow.

  1. Select New step to add an action to your flow.

  2. Enter relate rows into the Search connectors and actions search box on the Choose an operation card.

  3. Select Microsoft Dataverse.

  4. Select Relate rows action.

    Relate rows image

    Like other actions in this connector, a list of supported tables is available.

  5. Select the table to which you want to relate, or enter a custom value for the table name.

    Table name

  6. You will need to enter the identifier of the row you want to relate.

    Identifier image for the row to relate

    The list of supported one-to-many and many-to-many relationships based on the table type selected is populated in the format <Related Table Type> – <Relationship Schema Name>. You can select the relationship to which you want to relate your row.

    Relationship image

  7. Enter the full resource URL of the row to which you want to add the relationship.

    This URL is the full OData identifier of the resource, as shown in the following image.

    Full odata URL

    Tip

    You can get the row identifier URL from a previous step from the available dynamic content.

Unrelate rows

  1. Select New step to add an action to your flow.

  2. Enter unrelate rows into the Search connectors and actions search box on the Choose an operation card.

  3. Select Microsoft Dataverse.

  4. Select unrelate rows action.

    Your flow uses this action to disassociate two Dataverse rows if they are linked via a one-to-many or many-to-many relationship.

    Unrelate rows image

  5. Select the type of table you want to unrelate from or enter a custom value for the table name.

  6. Enter the identifier of the row you want to unrelate from.

    Table name and identifier

    The list of supported one-to-many and many-to-many relationships based on the table type you selected will be populated in the format <Related Table Type> – <Relationship Schema Name>. Select the relationship you want to unrelate the related table from or enter your custom value for the relationship schema name.

    The unrelate rows card

  7. Enter the full resource URL of the related table you want to unrelate. This will be the full OData identifier of the resource.

    Resource URL

    Tip

    You can usually grab the row identifier from a previous step by using dynamic content.

    Dynamic content from previous steps