web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Compose html - conditi...

Power Automate

Answered

Compose html - conditional (if a field is null or empty)?

(0) Share

Report

Report

Posted on by BertP

I have been using the following expression in a flow to include a <br> in html whenever a field did not have a blank or null value:

if(greater(length(items('Apply_to_each')['Address2ndLine']),0),'<br>','')

Now, however, the flow complains that the function "length" expects it's parameter to be an array or a string, not of type 'Null'.

I don't know if the function "length" has changed in its requirements.

Can anyone suggest a suitable replacement test for string vs null values?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @BertP ,
Do you want to check if the content is empty?
please try :
If the content is empty, it is '', if not empty, it is '<br>'
if(empty(items('Apply_to_each')['Address2ndLine']),'','<br>')

If this post helps, then please consider Accept it as the solution to help the other members find it.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
BertP on at

Like (0)

Report
Copy link

Link copied!

Perfect! Thank you so very much!

Was this reply helpful? Yes No

Join the conversation