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' )
Solved! Go to 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")
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"
)
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
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,
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")
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
194 | |
68 | |
46 | |
41 | |
28 |
User | Count |
---|---|
253 | |
120 | |
86 | |
84 | |
84 |