Results of Multiple Selection Lookup in ViewMode: clickable and row-wise

[Nuriel]

Greetings,

In "previous life" I have been using Nintex Forms, where a lookup field could be configured to select multiple results as follows:

As you can see, the items (lookup from a different list) are each in separate rows, which highly improves readability in comparison with power apps combobox, since these items contain a lengthy title.

When in View mode, the field would only show the results, again in each row as well as by default in form of a link to corresponding item without any further coding.

In power apps I would like to create a similar experience, however all by default dropdowns/combobox only show everything in one row and as text. My attempts to adjust this failed so far. I have tried to somehow use gallery or table in the edit screen, but without any success so far.

Any idea, how this could be accomplished?

Thx

[BCBuizer]

HI @Nuriel ,

Using galleries is definitely the way to go here. Can you please share where you go stuck when attempting to use them?

[Amik]

@Nuriel as I understand it, you're trying to create a Dual Pick List / Dual List Selector.

One basic example:

1. Insert two Gallery controls into your Screen and position them side by side. Ensure the Layout property for both are set to Title:

2. For the left Gallery, enter the following in the Items property:

Filter(
    ["Choice 1", "Choice 2", "Choice 3", "Choice 4", "Choice 5"], //you can replace this line with the source of your list. For example a Choice field
    Not(Value in colList)
)

3. For the left Gallery, on the OnSelect property of the NextArrow Icon, enter:

Collect(
    colList,
    ThisItem.Value
)

4. Set the Text property of the Label for both Galleries (which should be displaying an error) to:

ThisItem.Value

5. For the Items property of the right Gallery, enter:

colList

6. For the right Gallery, on the OnSelect property of the NextArrow Icon, enter:

Remove(
    colList,
    ThisItem
)

7. Change the Icon property of the Icon on the right Gallery to:

Icon.ChevronLeft

[Nuriel]

@BCBuizer : the issues are, that 1) Galleries do not pull data inside of datacards and using them outside of the form gets really ugly, at least in my form logic 2) I tried to populate the gallery from my combobox and couldn't find a solution to get it to work in general.

@Amik : I have built in your solution and get the following picture:

This works generally as intended in edit mode, but - the values would not save back to the column/datacard. Thus I tried to assign the values from the right gallery to the Update function of the datacard like this:

Update = {Value:colList}

Update = colList.Value

Update = Right_Gallery.Selecteditems

Update = Right_Gallery.Selected

Update = Right_Gallery.AllItems

Nothing works. How do I do this?

[Nuriel]

Update: I now managed to get results from the combobox to both gallery, listbox and a table, thus keeping the Update function of the datacard on the combobox. While gallery still only works outside the datacard, both listbox and table work inside as well.

I could live with this solution, since I do not necessarily require dual pick / select function. @Amik : still would welcome the solution to write the results back to the datacard/column.

With my above solution i would make combobox visible on edit screen only and e. g. a listbox visible on view screen only.

Unfortunately in all 3 cases the results are still text items and not native linked objects like in Nintex. Thus, I need some means to make those to hyperlinks.

From my understanding, I need somehow to split the Combobox.SelectedItems to single items and modify them to URLs via concatenating their value with the list URL & their IDs, make these single items to a collection again and feed this collection to the listbox/table/gallery.

Right?

[Amik · Accepted solution]

@Nuriel - the answer would depend on:

1. Your data source
2. Whether your using a Choice field
   • If you're using Dataverse, whether the Choice field is a Local Choice or Global Choice

Regarding Hyperlinks, a simple method is to use the Launch function on the OnSelect property of the Gallery Item to navigate the user to a specific URL based on the selected item.

[Nuriel]

Launch in onselect did it. Works as hyperlinks in the listbox as well, which currently would be my favourite way to go.

Now I just need to figure out the correct url syntax for the item, but this is another story and should not be that difficult.

Thanks again

[Amik · Accepted solution]

@Nuriel - I was about to write a long answer to your other question (how to get the data back into the DataCard) but decided to move it to a blog post:

https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/How-to-create-a-Dual-List-Selector-in-... 

[Nuriel]

Thanks a lot, that is most helpful as well.

Maybe one additional question: @Amik the onSelect works only in Edit Mode, in View Mode it is deactivated, both for the galleries and the listbox. Inside of datacards, that is. Loose on a screen it works well. I googled it and it seems to be a known bug.

Any idea how to workaround that? 

[Amik]

Hi @Nuriel - I am not clear on your question. As I understand it, the option to select a choice from the Gallery is disabled when the Form is in View Mode. This is by design and makes logical sense.

Unless I have misunderstood your question?