How to Set LookUp Value to Null Using Power Automate – Dataverse

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 🙂