Unanswered

Multi-select SharePoint column Control in PowerApps with data coming from another list - the On Change event of the control

(0) Share

Report

Posted on by JFImagery

Interesting (and maddening) problem. I have a multi-select choice field in SharePoint which needs to get its Items from another list in another site collection (essentially a "PowerApps Lookup", not a lookup column in SP). No problem, I thought, PowerApps can do this easy. I place the List.ColumnName into Items for the control in PowerApps, and the items show up fine. Also patch just fine if the form is NEW. However, when you try to EDIT this field and add more items, this is where the problems start. I can only access the selections which have been ADDED, not the selections which are coming from SharePoint. When I look at the collection, the items are blank - I assume because they come back as "Value" from SP, however, the column name from the data in the other list is "Title". At the end of the day, I need these in a collection with the CURRENT selections to patch back to SP. In the screenshots, "Honda SUV" has been added after pulling the item up in the form using a gallery. As you can see, those selections coming back from SP are blank. Those that are added are correct. Any help much appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

HI @JFImagery ,

This code you supplied

will start a new collection each time you run it based on the items you have selected in the combo box.

What are the Items of the combo biox?

Was this reply helpful? Yes No
JFImagery 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren, not sure of the question, it’s a multi select combo box, and it clears the collection because this code is in the on change event of the combo box. Thus, each time a user changes something in this combo box, it loads what the user has selected. It’s then patched back to sharepoint on submit...my main reason for including this is to show that when a change is made and this code runs, the image I uploaded shows that some of the items are blank (no missing, but blank). Thanks, Jim

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@JFImagery ,

That is why I asked you for the Items of the Combo Box - you are expecting to see a set of records and you are not seeing the ones you expect.

Was this reply helpful? Yes No
JFImagery 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Items is ExternalListName.columnname, in this case CarType.Title (the external list and column).

Was this reply helpful? Yes No
JFImagery 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Interestingly, I think Items is the crux of the problem. I'll attach screen shots, but creating a collection (or a Table, it works the same) from the SelectedItems of a multiselect field when getting items from an external list returns the name of the field as its "value". When I use "Choices('Example List'.Multiselect)" in the Items, when I create the collection from selected items, the header of the collection says "Value". When I use the external list CarType.Title, the collection header is "Title", with the items already saved to the list previously coming back blank. Any new items, as stated previously, are assigned to the collection properly. If there's a way to use the external list where it doesn't assign the header of Title, and instead one of Value, it would work properly.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@JFImagery ,

Without looking any further into this, to do what you have asked would be

RenameColumns( CarType.Title, "Title", "Value" )

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
JFImagery 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, @WarrenBelz , but this does not work. I ran the following code:
ClearCollect(colTest1, ComboBox5.SelectedItems);
RenameColumns('Car Type'.Title, "Title", "Value")

This does nothing to the Collection's column names...

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@JFImagery ,

The code needs to be the Items of the Combo Box (that is what you asked for)

RenameColumns( CarType.Title, "Title", "Value" )

If you then do the Collection

ClearCollect(colTest1, ComboBox5.SelectedItems)

you will find the field is called Value

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
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JFImagery ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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