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!
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:
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
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!