Answered

select NA text when no item from combo box is selected.

(0) Share

Report

Posted on by PrasadBabu Microsoft Employee

Hi every one,

I am using a Combo box. if we select multiple items from combo box the data should be stored as selected value display names separated by coma (,).
for this I have written below query which is working fine.
let us say I am using RequestorName Combo box, and display name is the name that is being concatenated.
Concat(
ComboBox_RequestorName.SelectedItems,
DisplayName,
","
)

but Problem is if I did not select any item from combo box it should show as NA.
i have implemented this but it is not working
Concat(
If(IsEmpty(ComboBox_RequestorName.SelectedItems)," ",ComboBox_RequestorName.SelectedItems),
DisplayName,
","
)

can anyone help on this?

Categories:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If(IsEmpty(ComboBox_RequestorName.SelectedItems)," ",

Concat(
ComboBox_RequestorName.SelectedItems),
DisplayName,
","
)
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PrasadBabu,

Have you solved your problem?

Do you want to display NA string in the Label when there is nothing selected from the Combo Box?

Could you please share a bit more about the scenario?

I have a test on my side, that the original formula as below could display nothing if there is nothing select from Combo Box:

Concat( ComboBox_RequestorName.SelectedItems, DisplayName, "," )

If you want the Label to display NA string, please modify your formula as below:

If( IsEmpty(ComboBox_RequestorName.SelectedItems), "NA", Concat( ComboBox_RequestorName.SelectedItems, DisplayName, "," ) )

Hope it could help you at some degree.