Setting string attribute in CDS to an empty string

[PowerMaverick]

How to set a string datatype attribute in CDS with an empty string value using Flows? I do not want to set null but instead an empty string literal. 

[Mira_Ghaly]

@PowerMaverick 

You have to set it to Null expression so it gets cleared.

[PowerMaverick]

But I want to set it to an empty string. CDS distinguishes between null & empty string and I have a requirement where if it is null then do X and if it is empty then do Y. If I can't set empty then I cannot do Y.

[JulienOlivier · Accepted solution]

Hi @PowerMaverick 

I just made some tests by settings the Null expression to a text type of field.
But in Power Automate, when testing the record against Null or Empty, it returns True to both.

What makes you think CDS can distinguish them?

[abm]

Hi @PowerMaverick 

Could you please refer the relevant documentation regarding CDS distinguishes between null & empty string?

Thanks

[PowerMaverick · Accepted solution]

My bad. I did a wrong testing which made be think it does distinguish between empty and null.

@LinnZawWin confirmed this via tweets 🙂. Check out the conversation thread on Twitter.