Unanswered

SPO List Checkbox Column into Collection Key:Value Pair

(1) Share

Report

Posted on by RJCTF

Does anyone know what the proper syntax is for adding a SharePoint list multi-select checkbox column into a Power Apps Collection key:value pair? I have the other columns working that are of type text and image.

"MOCA-WTW-Scenarios" is the sharepoint list name.
"ScenarioFocusAreas" is the column I am having trouble with.

I'd like it to be inserted into the Collection as an array of records. Like this.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

So you want it to show up as a table (which is what it will be) in that collection?

Was this reply helpful? Yes No
RJCTF 6 on at

Like (0)

Report

Hello - What I need is to insert the data into the collection as a double quote array like this: "selection1","selection2".

I have it posting correctly to the collection as a table. I thought I needed something special for that but apparently not. Here is the code as I have it now...

/*Collect for Scenarios*/

Clear(Scenarios);

ForAll('MOCA-WTW-Scenarios',Collect(Scenarios, {

ScenarioID: ThisRecord.ScenarioID,

ScenarioName: ThisRecord.ScenarioName,

ScenarioDescription: ThisRecord.ScenarioDescription,

ScenarioImage: ThisRecord.ScenarioImage,

ScenarioHelpLink: ThisRecord.ScenarioHelpLink,

ScenarioHelpLinkText: ThisRecord.ScenarioHelpLinkText,

ScenarioFocusAreas: ThisRecord.ScenarioFocusAreas

}));

When I hard-code it like this it works the way I want it to. The power app controls work properly.
Inside of the Collection it looks exactly the same as a table, but somehow it is stored slightly differently. If that makes sense.

/*Collect for Scenarios*/

Clear(Scenarios);

ForAll('MOCA-WTW-Scenarios',Collect(Scenarios, {

ScenarioID: ThisRecord.ScenarioID,

ScenarioName: ThisRecord.ScenarioName,

ScenarioDescription: ThisRecord.ScenarioDescription,

ScenarioImage: ThisRecord.ScenarioImage,

ScenarioHelpLink: ThisRecord.ScenarioHelpLink,

ScenarioHelpLinkText: ThisRecord.ScenarioHelpLinkText,

ScenarioFocusAreas: ["Organizational Productivity","Team Productivity"]

//ScenarioFocusAreas: ThisRecord.ScenarioFocusAreas

}));

Was this reply helpful? Yes No