Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Allow Setting null value to the lookup field in Common Data Service (current environment) connector

When we set the null value to the lookup field in Common Data Service (current environment) connector, the flow fails with the following error.




When the lookup value contains data it works correctly. But when I want to set it as null above error occurs while setting the value.

I am using below expression to update the lookup value.



FYI, i tried using  ' ' instead of null but it still fail. Any solution?


Thanks in advance!

Solution Sage
Solution Sage

Hi Ankita,


Have you tried using the DELETE method the way it is done in web api . Try using Invoke an HTTP Request with Azure AD connector and pass the required parameters




Hello @Ankita2020 .


Unfortunately at this time flow does not support CDS Lookup values to be set as null.

You can try leaving the Lookup value blank. (This might cause issues later on, since you will not be able to filter on them)


You can vote for this feature here:


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up

Proud to be a Flownaut!

Check out my blog for Power Automate tips,
tricks, and guides

Hi Ankita,


Please try with Unrelate Records action available in CDS(current). PFA screenshot which I tried removing primary contact from Account

 In the item id provide the guid of contact record and URL also provide the guid of account




Also DELETE request works for single valued navigation property using HTTP Azure AD request 


invoke request.JPG


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,875)