Power Apps Combo box concatenate display fields

(0) Share

Report

Posted on by HM-22080408-0

Hi Members,

I have a requirement in Power Apps Combo box concatenate display fields

I have a SharePoint list [IT Service Request], that has a choice column as Issue with the below choices:

Outlook
Laptop
Network
Other

Cmb error.jpg

Now On my Power Apps screen, there is an Edit form. In the form, there is a combo box control connected to the above SharePoint list choice column.

Whenever the user selects an Other option, there will be a Text-input control visible

Cmb error 2.png

When the user provides a text and clicks on the submit button.

The combo box selected value and text input value should be saved in the SharePoint list choice column. So it should concatenate both control values.

So on the Update property, I tried the code below:

Concat(ForAll(DataCardValue3.Selected.Value, Value & If(Value="Other" && Not(IsBlank(TextInput2.Text)), ": "&TextInput2.Text, "")),Value, ", ")

But I was facing an Error for this.

Can anyone please suggest how I can resolve this? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Hemashree ,

Try this

Concat( DataCardValue3.SelectedItems, Value & If( Value = "Other" && Not(IsBlank(TextInput2.Text)), ": " & TextInput2.Text, ", " ), ", " )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report

Hi @WarrenBelz Thank you for your response

Actually, I implemented the same code as you mentioned. But I am facing an error as "Expected Record Value" as shown below:

I have implemented this code within the Issue DataCard Update property.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

@Hemashree ,

DataCardValue3 needs to be Multiple Selection

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report

@WarrenBelz
My DataCardValue3 allows multiple selection

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

@Hemashree ,

Something else is wrong here - I just tested the code I posted on a Multi-Select Combo Box and a Text input (which I assume TextInput2 is) and it worked as expected. What is the Items of DataCardValue3 and can you also please post all code in text (as well as the image if you add one)

Was this reply helpful? Yes No