Answered

SharePoint multiple choice column to Power Apps variable or collection.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I have been reading posts all day trying to solve this issue.

I have a situation where I have a combo-box in my app that is submitted to a sharepoint list choice column with multi select enabled.

The list item is populated by power automate. This works fine.

My issue is trying to read back the value/s in this column. I am displaying the list in a gallery control in my app, and need to be able to populate the combo-box in the app with the values present in any given item in the list/ gallery.

I have a button in the gallery and have tried the following,

ClearCollect(allowancesColl,ThisItem.Allowances)

and

Set(allowancesVar,ThisItem.Allowances)

however these are returning nothing to the collection or variable. I need to return a record to be able to set the "DefaultSelectedItems" property of the combo-box.

What is the datatype returned by a multi-choice field from SharePoint? How do i create a record in Power Apps from this?

Thanks in advance.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
A column with multiple choices enabled typically returns a table with a single column named Value. If you need to access these in a label or other text format, a Concat can combine the values together into a string. Example:
Concat(myColumn, Value, ", ")
Hope that helps,
Bryan
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
That doesn't seem to work.
I tried adding a text label to the gallery, and in the text property using the formula
Concat(ThisItem.Allowances,Value,", ")
&
Concat(~column name~.Allowances,Value,", ")
both of which have errors.
This is not really what i was wanting to achieve anyway (but would be nice to understand)

Using Power Automate to pull the column field, I get an array of objects,
[ { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 0, "Value": "LAHA" }, { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 1, "Value": "Meal" } ]
I would like to set the "DefaultSelectedItems" of my combo-box to the values in the SharePoint list. In the above example that would be "LAHA" and "Meal".
The "Items" property of the combo-box and the choices in the list are the same (the list will not be manually edited, so it doesn't matter where these are stored if it needs to be one or the other).
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
OK, you find the Distinct() function useful for populating the Items property of the combobox:
Distinct(myTable, Value).Result
Note, when using Concat() on the output of a control that uses Distinct() for Items, the resulting column is labelled Result not Value.

Bryan
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks Bryan,

What ended up working for me,
To add the items to a text label field in the gallery,
Concat(ThisItem.Allowances,Value,", ")

To add the values of the multi choice SharePoint column to the selected items of my combo-box (where 'Allowances' is the column name in the SharePoint list),
In the "OnSelect" property of a button in the gallery,
Set(allowancesVar,ThisItem.Allowances.Value);Reset(ComboBox1)
In the "DefaultSelectedItems" property of the combo-box,
allowancesVar

The missing link was the "Reset(ComboBox1)" operation.
I now have a button in my gallery which will pre-populate the app fields with the values present in the SharePoint list.
Sarojkumarmishr 3 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked for me. in a data table and for multi choice SharePoint column.