web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :

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

Ram Prakash Profile Picture Ram Prakash 5,520 Super User 2025 Season 2

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 🙂

 

 

Comments

*This post is locked for comments