Show Values in form based on what is selected in Gallery - Issue with 'Allow Multiple Selections' Dropdown

(0) Share

Report

Posted on by RewriteScript

Hey guys,

I hope you can help.

I have a gallery and a form linked to the same SP list. I have it function so that when I select an item in the gallery, the values in the form beside it populate with the selected item details.

Everything works except the dropdown where I have 'Allow Multiple Selections' active within PowerApps and the SP List. Multiple items need to be chose in this field.

Form - Item:

LookUp('SP LIST', ID = Gallery2_2.Selected.ID)

Multi-Select Dropdown - Items:

Choices([@'SP LIST'].COLUMN NAME)

Any help would be massively appreciated!

Thanks 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

MudassarSZ365 591 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RewriteScript ,
Here's what you should do for the multi-select dropdown in your form:
Set the Items Property: This defines the list of choices available in the dropdown.
Items: Choices([@'SP LIST'].ColumnName)
Set the DefaultSelectedItems Property: This defines which of the items in the dropdown should be selected by default when you select an item in the gallery.
DefaultSelectedItems: Gallery2_2.Selected.ColumnName
Kindly mark the solution as accepted if it resolves your issue.
Best Regards
Muhammad Mudassar Mazhar

Was this reply helpful? Yes No
RewriteScript 68 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much Muhammad Mudassar Mazhar! That works a treat! 😄

Was this reply helpful? Yes No
Verified answer

RewriteScript 68 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey! I found that alongside the brilliant advice Muhammad Mudassar Mazhar has given, you also need to wrap the function in a value for multiselect dropdowns.

Like so:
{Value: GalleryName.Selected.ColumnName}

Was this reply helpful? Yes No