Null value preventing email from running

[DCNehs]

I've gone through several different discussions and tried a few different things but I'm still not able to get my workflow to run.

I have about 5 multiple lines to text columns and 4 of them would normally not be filled out until a different part of the review process later on.

I have a few compose items set up with a replace so that the information shows up correctly in the email,  however the email will only send if there is text entered.   Hoping there is a way to either enter default text or a workaround.  I tried using length but I think I may be missing something somewhere.

VERY new to formulas.

Thanks!

[efialttes]

Hi!

Default text in case of null?

coalesce() WDL based expression should do the trick

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#c...

Hope this helps

[abm · Accepted solution]

Hi @DCNehs 

Below is the expression you need to use.

replace(coalesce(outputs('ComposeInterimAction'),''),variables('EnterKey'),'<br>')

@efialttes , I had a conversation with @DCNehs  regarding another post and this was part of the fix. Thanks @efialttes  for the update.

[efialttes]

@abm 

No problema. My first response was just a general recommendation.

Guys like you make Power Automate community awesome. Thanx for providing the detailed expression!

[DCNehs]

thank you @abm and @efialttes !  This community is amazing!