Label from Excel to display if none

[Lmcginnis]

Hi,

Is there a way to Display a value when there is an empty table? in this type of useage,

Concat(ComboBox1_1.SelectedItems,"Contact" &"-"&Contact&'Main Number'&'Alt Number' )

So if there is not a Contact, Main, or Alt Number, is there a way to display something like, xxx or xxx-xxx-xxx ?

Thanks,

[timl]

Hi @Lmcginnis 

You can use the Coalesce function to do this:

Coalesce(Concat(ComboBox1_1.SelectedItems,
                "Contact" &"-"& Contact &'Main Number' &'Alt Number' 
          ),
          "xxx-xxx-xxx"
)

[v-yutliu-msft]

Hi @Lmcginnis ,

Do you want to display a string as the format of “xxx-xxx-xxx” when one of the fields having a null value?

I’ve made a similar test, you could refer this:

Concat(ComboBox2.SelectedItems,

                                                               "Contact"&

                                                               If(IsBlank(ComboBox2.Selected. Contact),"","-"& Contact)&

                                                               If(IsBlank(ComboBox2.Selected. 'Main Number'),"","-"& 'Main Number')&

                                                               If(IsBlank(ComboBox2.Selected. 'Alt Number'),"","-"& 'Alt Number')

             )

Best regards,

Community Support Team _ Phoebe Liu

[Lmcginnis]

Hi,

Can seem to edit you suggestion to work for my needs.

But yes, if the excel field is blank (a phone number) I would like it to display "XXX-XXX-XXXX" .

my current lable is formatted as,

Concat(ComboBox1_1.SelectedItems, 'ER Phone')

and I have tried, 

Concat(ComboBox1_1.SelectedItems, 'ER Phone')If(IsBlank(ComboBox1_1.Selected. 'ER Phone'),"","-XXX-XXX-XXXX")

It doesnt appear to work for me.

Thanks,

[Lmcginnis · Accepted solution]

HI,

I think I got it to work, when I noticed I wasnt using the & function to call the "if" function, but then it was always displaying the "xxx-xxx-xxxx" .. so I tried this "!IsBlank" and it worked

Concat(ComboBox1_1.SelectedItems, 'ER Phone') & If(!IsBlank(ComboBox1_1.Selected. 'ER Phone'),"","XXX-XXX-XXXX")