Power Community

Power Community

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

rampprakash_0-1696492380939.png

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

rampprakash_1-1696492452921.png

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'),
        ')'
    )
)

rampprakash_2-1696492749317.png

That’s it 🙂

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Preferred Solution | New feature | Microsoft Dataverse

Click on the below image to navigate to my YouTube Channel. Please like and share your valuable feedback on this...

More Articles Like This

- Advertisement -spot_img