How to extract values from a SharePoint list column with multiple values to a gallery in PowerApps

[cleve]

My PowerApp runs on a SharePoint list. My SP list uses a lookup column and is set to "allow multiple selections." I want to list the values from this column in the Subtitle1 field of a gallery or in the cells of a data table.

[WarrenBelz]

@cleve ,

If you are referring to the selected values from this control

Concat(
   YourComboBoxName.SelectedItems,
   Value & ", "
)

will list them with a comma and a space between them.

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.

[cleve]

I don't know what the combobox is referencing. The only objects I am dealing with are a gallery and SharePoint lists.

[WarrenBelz]

@cleve ,

Sorry a bit lost here - what are you trying to list? If it is all the items possible to select, just to the same lookup in Power Apps (it will have to be a Filter)

[cleve]

All I have so far is the default 3 screen app from my SP list.

In the Test-SalesData list, the 'Broker (Buyer)' column is a lookup which points to this one-column list:

I want the selections for the 'Broker (Buyer)' column to be the Text value for the Subtitle1 field in my gallery.

I tried to use Search and Filter but I can't get the syntax right.  I thought I could use something like this:

Search( 'Broker (Buyer)', "", Broker )

[WarrenBelz]

@cleve ,

Are you referring to the related column of the LookUp (you are selecting Broker and you want to display buyer?)

I am still unclear what you want to to. Also how are you selecting them or do you just want all the possible selections?

[cleve]

There is a broker for the buyer and a broker for the seller, so I have named the columns Broker (Buyer) and Broker (Seller). I want to list all of the values selected in the "Broker (Buyer)" column. The options for that column come from a lookup so I thought it was worth mentioning. 

Everything I have tried gives the error, "This formula uses scope, which is not presently supported for evaluation."

[WarrenBelz]

@cleve ,

To be clear here - your Lookup column is Broker (FG, BD etc) and it is looking up Broker (Buyer) and Broker (Seller) in another list and you want to list all the Selected items (FG, BD etc) in the related Broker (Buyer) column in the gallery?

Further you want to have these as a single line of text?

Firstly, you might have a read of my comment on Lookup columns in the Field Type area of my blog on data structure.

I will go back to my first post here - you need to do the LookUp in Power Apps as the underlying value required in a lookup column is actually the ID of the record in the other list you are referring to. This is possible to some degree when referring to the "primary" (Broker) field, but you are doing a "lookup in a lookup" and multi-select (actually a record) and want to generate a many-to-many query within this.

Before I consider going further, have I summarised this correctly?

[cleve]

@WarrenBelz
After reading your blog posts I started over and rebuilt my original list using only text and number types. Regarding choice types with multiple selections, your blog mentions this, "You may need to use them however if you want multiple choice options."

I tried the code you mentioned earlier to test this by populating a text label with a combo box: 

Concatenate
	(
	Combo_Broker.SelectedItems,
	Value & ", "
	)

I am getting a type error:

 

Not sure what to do here as Power Apps confirms the type is 'table' in the formula bar.

[WarrenBelz · Accepted solution]

@cleve ,

Yes - you need a Choices column if you want to hold multiple values, but unlike a Lookup column, the table has only one field - Value (so you are not needing to get the ID of the other list lookup up). So your drop-down with multiple choices needs to write back to a Choices column (it does not matter what the choices are in your list - just hard-code what you need in the Items of the control in Power Apps.

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.