Unanswered

Unable to build array for multiple checkbox selection Sharepoint list item

(0) Share

Report

Posted on by eferreira7

I'm trying to take a Sharepoint List I've created that contains 2 columns with multiple text selections from a drop-down and send the results in an email. I've found that Power Automate can't handle this. I spent a good deal of time researching how to initialize and append to an array variable so I can output these values. After about 1-2 hours of trial & error troubleshooting I can't seem to figure out how to do this.

Screenshots:

Multiple selection items in the SharePoint List:

Column settings in SharePoint:

Error from Flow:

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report
Hi @eferreira7,

You could use a Select action and a join function for this.

Below is an example of that approach.

1. Add a Select action. Use the Build Selection Array in the From field. Use the following expression in the Map field (Switch Map to Text mode)

item()?['Value']

2. In the Send an email (v2) use the following expression. This will separate the items with a space character.

join(body('Select'), ' ')

You could also use a comma

join(body('Select'), ',')

Was this reply helpful? Yes No
eferreira7 4 on at

Like (0)

Report

Gave that a shot. That only works with Strings and not arrays.

Error:
The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Was this reply helpful? Yes No
Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report

Hi @eferreira7,

Can you test it without the apply to each. That action is not needed for this solution approach.

Was this reply helpful? Yes No
eferreira7 4 on at

Like (0)

Report

Unfortunately, that's not an option. The moment you select that Variable (array) it automatically encapsulates in an "Apply to Each".

Was this reply helpful? Yes No
Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report

Hi @eferreira7,

To avoid that apply to each you could use an expression instead of selecting the dynamic content field.

Was this reply helpful? Yes No