Label from Excel to display if none

(0) Share

Report

Posted on by 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,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

timl 37,271 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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"
)

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Lmcginnis 37 on at

Like
a
(0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Verified answer

Lmcginnis 37 on at

Like
a
(0)

Report
Copy link

Link copied!

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")

Was this reply helpful? Yes No