Answered

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

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

WarrenBelz 154,966 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
cleve 88 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,966 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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)

Was this reply helpful? Yes No
cleve 88 on at

Like (0)

Report
Copy link

Link copied!

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 )

Was this reply helpful? Yes No
WarrenBelz 154,966 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
cleve 88 on at

Like (0)

Report
Copy link

Link copied!

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."

Was this reply helpful? Yes No
WarrenBelz 154,966 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
cleve 88 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,966 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
cleve 88 on at

Like (0)

Report
Copy link

Link copied!

I wan to cover all of the steps for someone who comes across this post. Below you can see the Items property of the data card in the form to create a new record. Once the column was changed to a choice column on my SP list, I had to delete the card and close the editor. Then I was able to open it back up and add the card for the "BrokerForBuyer" Column. Once the card was added back, I pointed the 'items' property to the 'LookupBroker' SP list and it works as expected.

Was this reply helpful? Yes No