How to Set Lookup Value to Null Using Power Automate - Dataverse

Introduction:

In this Blog, we will see how to set Lookup Value to Null using Power Automate

Implemenation Steps:

 

1. Navigate to https://make.powerautomate.com

 

2. Click My Flows

 

3. Create a New Flow.

 

4. Once the Flow gets Created add the Variable

 

 

5. Now For Demo am using Owner ID as Variable Set Some Dummy Variable

 

 

6. Now for Updating Lookup You cannot Directly Set it to Null So You can use below two Expression to Achieve the same.

 

You can use '' (Single Quotes) to set it to Null

 

if(
    empty(variables('Owner ID')),
    '',
    concat(
        'systemusers(',
        variables('Owner ID'),
        ')'
    )
)

 

Else you can use NULL to set the same 

 

if(
    empty(variables('Owner ID')),
    null,
    concat(
        'systemusers(',
        variables('Owner ID'),
        ')'
    )
)

 

 

 

That's it