Answered

Modern Combo Box show multi-slect choice column from SharePoint list

(0) Share

Report

Posted on by Harry_rx

I am trying to add a combo box on a canvas app to allow users to show and select select multiple choices from, a SharePoint list column.

The list is called Board Members and has a multi-select column called Membership.

In the [Items] field I have tried :

but as you can see it just returns [Table] and the dropdown just shows nothing next to the checkboxes.

If I place my cursor at 'Choices' It does show the values in the expression editor preview:

I have also tried:

But now it shows blank entries at runtime:

The reason I am using a Combo Box is because I want to be able to use Patch instead of using the a form.

Can anyone please advise? It's driving me nuts.

Really appreciate any help that can be offered.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

hi, @RIYxWRK

That is weird, normally that would happen if you selected a value that was, lets say a table, and the default Column (in sharepoint) had no value in it, like Title (and you hid it).

Us this a true choice, or a lookup column? It could be that its a Choice, but a Choice of Records (like people), so you would need to pick which Column to display like Display Name etc
So you would use an Edit / Field picker in the Right side Properties, first tab.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

Harry_rx 96 on at

Like (0)

Report
Copy link

Link copied!
Looks like this may be a bug with the modern Combo-box.

I inserted the legacy version, and it works with:
Choices('Board Members'.Membership)

Legacy box:
at runtime produces the correct values:

So it looks like the modern controls are buggy and shouldn't be trusted yet (I know they are preview but that's super annoying.).

Was this reply helpful? Yes No
Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Good

Was this reply helpful? Yes No
JimBorgAu 2 on at

Like (0)

Report
Copy link

Link copied!

Can confirm as of date of post, that the Modern Dropdown tool wasted a few hours trying to get it to display a SharePoint list.
Flipping back to the classic dropdown worked first time. 😣

Was this reply helpful? Yes No