When updating rows using the CDS Current Environment Connection lookup values must be proceeded with the entity name for the reference. For example;
![](https://grootcrm.net/wp-content/uploads/2021/04/LookupIsNull1.jpg)
But what if the ID is empty? In that case an error wil occur because the reference is null.
There is a (really nasty) solution to get around this, using a formula in stead of the entity name + GUID:
![](https://grootcrm.net/wp-content/uploads/2021/04/LookupIsNull2.jpg)
And the formula is:
![](https://grootcrm.net/wp-content/uploads/2021/04/LookupIsNull3-1.jpg)
If anyone has a better solution, please let me know :-).