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

(0) Share

Report

Posted on by Nuriel

177

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

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (2)

Sort by

BCBuizer 22,819 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI @Nuriel ,

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

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
Nuriel 177 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nuriel 177 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Nuriel - the answer would depend on:

Your data source

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.

Was this reply helpful? Yes No
Nuriel 177 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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-an-EditForm/ba-p/2399332

Was this reply helpful? Yes No
Nuriel 177 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Nuriel 177 on at

Like (0)

Report
Copy link

Link copied!

Well, it make sense, if you want to edit the gallery items, but it does not make sense, if you want to just click on the item to get it's properties. I want my users to open a form in view mode, e. g. when the item is locked for editing and be able to click on each gallery item, resulting in browser window with the URL of that item to open.

This works only in edit mode though. And it would be great to find some solution for this to work in View Mode as well.

Was this reply helpful? Yes No