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")
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
198 | |
172 | |
61 | |
32 | |
32 |
User | Count |
---|---|
336 | |
271 | |
104 | |
71 | |
56 |