Answered

Best way to display and edit multiple option list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a sharepoint list with a "Distribution List" column. The column offers multiple choices to select from and you can select more than one.

I have a form within PowerApps that uses a drop down box to select these items.

Elsewhere in the app I'm working on, I want to display the selected items and have the ability to change which items are selected or add additional items. Currently, I have the items displayed in a list box. Works fine... it's not the best, I don't love it... but it works fine. However, I can't seem to figure out how to allow users to edit the options.

Does anyone have a suggestion on (A) how I can display the selected items in a more efficient way and (B) How I can allow users to edit the selections?

Thanks in advance for the assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

jhall 636 on at

Like
a
(1)

Report
Copy link

Link copied!

The classic ListBox kind of add/remove is the old Windows pair of listboxes. Where one box (on the left) has what you could include and the other box (on the right) has what you are including. You select an item on the left, hit the > button and add that item, or hit the >> button and add everything. Similar for removal (e.g. <, <<). It's...OK. Same kind of annoyances as you might be dealing with though. However, at least it is familiar.
You'd need to do some logic around enabling/disabling icons/buttons though for if the left/right list is empty/full.

Was this reply helpful? Yes No
jhall 636 on at

Like
a
(1)

Report
Copy link

Link copied!
But now you made me curious and I did a test which worked fairly well.
Create a Collection
ClearCollect(myUserList,{name:"John",include:false},{name:"Sally",include:false},{name:"James",include:false})
Create a blank vertical Gallery
Change the Items for the Gallery
Filter(myUserList,include=false)
Select your Gallery
Add a Button
Resize your Gallery/button so it fills the field
Select one of the Gallery's buttons
Change the Text
ThisItem.name
Change the OnSelect
Patch(myUserList,ThisItem,{include:!ThisItem.include})
Select the Gallery and Copy/paste a new copy
Move the new copy next to the original
Change the new copy's Items value
Filter(myUserList,include=false)
Run the app
Clicking on the Buttons in the gallery changes the value of the include Boolean and moves the item Gallery to Gallery. Easy add/remove.
The extra-slick thing is that now you could also add in an additional search/filter field above to quickly find users (or products/etc.) via the same method in the left-hand column (to be added). As well, since it is a Gallery, it should be obvious that you could add user photos, etc. as well.

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

For your first question,there are many controls you can display the selected items,for example, Gallery, data table...

And which control is the best way to display the items,it is very difficult to say, it decided by you.

For your second question, you want to edit the selected items, how do you mean edit them? Concatenate or split or other changes?

Best Regards.

Yumia

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the help everyone 🙂 I was looking for a very simple solution and ended up just using the combo box function. When it's set to view, it displays a list of all the selected distribution lists the user has selected. When it's set to edit (updated with a variable) it allows the user to select additional lists to be added to or remove lists they shouldn't be on. Although I do like the gallery idea and may use that in the future!

Was this reply helpful? Yes No