Answered

Show multichoice values from SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've created a small PowerApp that is connected to a SharePoint list. Now I want the users to be able to see the values from a multi-choice field. Since this is not possible out of the box I wonder if anyone has a clever work-around for this? The users don't have to be able to edit these entries, only read.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

Support for multi-choice fields is coming. Do not know exactly when, but in the announcement blog it says soon. So my advise would be: wait a little while.
https://powerapps.microsoft.com/en-us/blog/custom-form-launch/
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous@Rebetcha,

Actually, we have already annouced the availability to use choice, lookup & people columns in SharePoint lists that have multi-select enabled on them. But notice that:

These changes are rolling out incrementally for SharePoint First Release tenants and are not generally available from SharePoint yet. So, if your tenant is already on first release, you should already have them and if your tenant is not on first release, to enroll please follow the instructions here.

Announcing availability of custom forms, multi-value choice and read-only attachments support for SharePoint with PowerApps

https://powerapps.microsoft.com/en-us/blog/custom-form-launch/

Check and change your tenant to first lease in Office365 admin center > Settings > Organization Profile > Release Preferences. I just tested myself. Before, I was unable to use the multiple selection column with ComboBox under stardar release. After I change it to first release, and wait for 24 hour. I create the app using sharepoint list connection, all my multiple selection columns are shown with combo box:

Regards,

Mona
spacecdc 15 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi
How do you get the field to show in the Gallery.

Using your people example I have tried Thisitem.People.value with the Text property but get the error:

This property expects text values, this rule produces incompatible table results.

For a choice field without multiple values Thisitem.singlechoice.value usually works.

Thanks in advance for any help
Xinyao 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the same question.

How do you get the field to show in the Gallery.

I want to filter on the values
Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

@Xinyao wrote:
I have the same question.

How do you get the field to show in the Gallery.

I want to filter on the values

Can you describe your scenario in a new thread? And maybe give a little bit more information of your scenario.
VojtaK 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the same question, how to show a multichoice value in a field ?