Sharepoint multi choice values

(0) Share

Report

Posted on by MM-05080756-0

410

So, I've struggled a lot with this without finding a solution. I really would appreciate some help.

I need to fill a repeater in a Word template with data from a Sharepoint list, where one of the columns is a multi choice. I find no way to get the data right.

I need to put together all the choices from each list item separately.

This is my list (stripped down to only what's needed for testing. Kryssrutaflerval = multi choice column, others are text columns.

But this is what I get in the Word file.

This is my Flow in the state it is now. Clearly, it is the "Append to array variable" that messes things up. That's the way I use when I have only one item to deal with, or when I want to join data from different items. But here, it doesn't work for apparent reasons.

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

Tomac 3,181 Moderator on at

Like (0)

Report

Sharepoint multi choice values

Hi @MM-05080756-0

It would help to see more of your flow, so we have the full context. From the screenshots it doesn't appear you're resetting the array variable at any point, but your output screenshot doesn't show evidence that the array is additive over each iteration.

Was this reply helpful? Yes No
abm abm 32,611 Most Valuable Professional on at

Like (1)

Report

Sharepoint multi choice values

Hi

You got two apply each which is ok to me. The second apply to each is collecting the array values for each row. move the join after the second apply to each. Add a compose and construct the values like this

{
"Title":"Map title here",
"Kyrssrutaflerval":"Here map the output
}

Then declare an array variable above then use the append to append the compose output

Finally outside the loop Add the Select and map each values. Finally you can use this under the Populate template.

1 people found this reply helpful.

Was this reply helpful? Yes No
David_MA 12,568 Super User 2025 Season 2 on at

Like (1)

Report

Sharepoint multi choice values

As @abm abm pointed out, the variable you are appending to is combining the choices from all of the items from the Get items action. I think what you want to achieve is in the Choices column below that I generated from a test list:

I don't know of any easy way to achieve this when using the Select action as it cannot process two arrays of data at the same time. But you can achieve this by using the following type of expression in the select action for the multiple-choice field:

concat(if(empty(item()?['MultipleChoice']?[0]?['Value']), '', item()?['MultipleChoice']?[0]?['Value']), if(empty(item()?['MultipleChoice']?[1]?['Value']), '', concat(', ', item()?['MultipleChoice']?[1]?['Value'])), if(empty(item()?['MultipleChoice']?[2]?['Value']), '', concat(', ', item()?['MultipleChoice']?[2]?['Value'])))

Note: In my list, there are three possible choices. You will need to expand the above code to as many possible choices that you have. It relies on the index value of the choices ([0], [1], [2]), so just increment the value for as many choices you have. I also have not extensively tested this, but it seems to work.

IP addresses listed above are made-up and if they match any real IP address that was not my intent. This field just happened to be in my test list for something else.

Was this reply helpful? Yes No