How to populate textbox based on multiple selection in another combobox

[Anonymous]

Hi I have a sharepoint list with two columns named as REF ID and CDE Name Text as shown in below image-

I have created a multiselect combobox in my powerapps app as shown in below image-

I want to populate my textbox with the corresponding CDE Name Text values based on multiple REF ID selection in the above combobox.

For example - If I have selected BID02, BID03, BID04 in my combobox at once, I want my textbox to display CDE Name text values of those selections such as   -  Organization Identification Number for BID02, Geo Ref ID for BID03 and Primary Business Name for BID04.

so once I select BID02, BID03, BID04 in my combobox

My textbox should store values like - 

Organization Identification Number , Geo Ref ID , Primary Business Name 

in one textbox separated by commas or dash whatever is applicable

I have tried everything but is not able to achieve this , can you please help me with this as I am very new to the powerapps.

[RusselThomas]

Hi @Anonymous ,

The Text: property of your text label might look something like this;

Concat(ComboBox.SelectedItems, 'CDE Name Text', ", ")

Hope this helps,

RT

[Anonymous]

Hi This is not working for me as CDE Name Text is the name of the column and its only coming when I am specifying sharepoint list name as well but its not working 

CDE - Reg is the name of sharepoint list

can you please tell how I can handle this issue?

[RusselThomas]

Hi @Anonymous ,

The reference in the formula is the combobox items, so the scope is relevant to the fields in the combo box, which is no longer your SPO list.  This is why referencing SPO as part of the same formula allows you to select the right column, but kicks out an error in the context of the overall formula.

Two things could be happening here;

• Your combobox Items: property is limiting it to a specific field, meaning the column we're looking for isn't there
• The name of the data field is different to it's Display name (doubtful as you found it with the SPO reference, but possible)

For the first issue, check what your Combobox Items: property expression is.

It's okay if it's filtering your source, but it should not isolate it to a specific column.  For example;

'CDE - Reg'

is fine, because you can still set your "SearchFields" and "DisplayFields" to ["Ref ID"], but putting 

'CDE - Reg'.'Ref ID'

in the Items: property limits the combobox to only the Ref Id column.   A filter is fine, but limiting it to one column won't help us here.  I know it makes sense like this, because your combo is only showing one column, but for this to work it helps for the combo to have visibility of the whole record even thought it's only displaying one column.

Can you please check that and let me know?

If it's a difference between the field name and the display name, we can troubleshoot that further.  First let's check the above.

Kind regards,

Russel

[Anonymous]

My combobox item has this , to populate only the REF ID column values

if I will change this I will not get option any more to select REF ID values from combobox

is there any changes that I need to make here??

[RandyHayes]

@Anonymous 

Can you share the Items property of your Combobox?  This will determine what is able to be stored as you are looking to do.

You also have different types of information that you want to store based on certain values selected.  This can all be handled in the Items property of the Combobox, but I would need to know your logic for the different values.  For example, you say that if BID02 is selected that it would have Organization Identification Number - would that always be the case?  Just as, would it always be the case that if BID03 is selected that Geo Ref ID is what you want for that?

Also, will you ever be expecting to edit the underlying text information with the combobox again?  If so, then you will also need to store the selected values so that when you edit the record, you can reverse the concatenation of the text back to the appropriate selections.

[RusselThomas]

Hi @Anonymous ,

If you're using Distinct() because there are multiple rows that contain the same 'Ref Id', then getting their respective 'CDE Name Text' reliably depends a lot on your data.  This might mean doing things the long way round. 

If we can we assume that the "CDE Name Text" for each instance of "BID 01", "BID 02" and so on would always be exactly the same respectively, and if the source column is not already unique, then you can try this;

AddColumns(Distinct('CDE Reg', 'Ref ID'), "CDE Name Text", LookUp('CDE Reg', 'Ref Id'=Result, 'CDE Name Text'))

This really is not a very efficient way of doing it though and can cause some slowdown in your combo.

Possibly a better option is to pass this to the text label instead, so the extra lookups only happen for the selections the user has made, instead of the whole list of Distinct() items;

Concat(ComboBox.SelectedItems, LookUp('CDE Reg', 'Ref Id'=Result, 'CDE Name Text'), ", ")

Please do bear in mind, if 'CDE Reg' is a large table, then you have to be 100% certain all variations of 'Ref ID' appear within the first 500 (or 2000) rows (depending on your data row limit settings) - if not, your initial Distinct() function might then not return all the Distinct() variations.

Hope this helps,

RT