Combine SharePoint List Columns in ComboBox Result

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have Radio Control1, ComboBox1, and Gallery1.

I have the need to combine multiple fields in the results of ComboBox1 if Radio Control1 is not blank.

If the Radio control is blank filter the Collection/Gallery1, A - Z by FullName (SP List column is Subscriber_Full_Name).

If 'FullName' is selected in the Radio Control1, filter the Collection by FullName (A-Z), with and Title column content.
Example: Smith, Joe, SMJO123

My first attempt was the following, but I am getting errors. What am I missing?
If(IsBlank(Maintenance_Filter_Choice_Radio_Control.Selected.Value),Filter(Concatenate(Subscriber_Address_Collection,Subscriber_Full_Name && Title)))

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Phineas ,

It seems you would like to combine multiple columns values into the display field of a Combo box. If this is the case, then you need to add another column to the collection and show this column as primary field.

Items of combo box:

AddColumns( Sort( Subscriber_Address_Collection, Subscriber_Full_Name, SortOrder.Ascending ), "Combined", If( IsBlank(Maintenance_Filter_Choice_Radio_Control.Selected.Value), ThisRecord.Subscriber_Full_Name, Concatenate(ThisRecord.Subscriber_Full_Name,", ", ThisRecord.Title) ) )

Best regards,

Was this reply helpful? Yes No