Skip to main content

Notifications

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 🙂

 

 

Comments

*This post is locked for comments