Populate a word template with multiple choices from a drop down

[johnkebab]

Hi All,

   I have a Risk Assessment within an app that used drop downs - the data source is a SPO list with multiple choices allowed - I am trying to get all choices selected from the drop down in the app to be imported into the .doc.

  Currently only the 1st choice is imported.  I have tried editing the flow and also using the concatenate function in the app, but this just repeats the 1st option 3 times:

i.e. the default is this:

Task1haz.Selected.Value, and I have also tried Concatenate(Task1haz.Selected.Value, Task1haz.Selected.Value, Task1haz.Selected.Value,)

There is no option to use 'SelectedItems'.

In the power automate flow, I have tried using the same dynamic expression, repeated 3 times, but it has the same effect.

The data source is a SPO list which allows multiple selections

I'd love to know what I'm doing wrong - does a multiple choice drop down need to have multiple selections put into a collection before all the selections are processed?

Thanks for any help

[BCBuizer]

Hi @johnkebab ,

Since you are using .Selected, only one item is returned. To return all selected items, use .SelectedItems.

You may want to combine that with a Concat function to convert the items to text, for example:

Concat(Task1rescons.SelectedItems, Value, "; ")

[johnkebab]

Thanks @BCBuizer, the SelectedItems function just reds out for me:

[BCBuizer · Accepted solution]

Hi @johnkebab ,

That is because .SelectedItems will return records, rather than text which is what the flow expects. Please use the Concat function as mentioned in my previous post to convert the records into text.

[johnkebab]

Thank you so much! This had me head scratching for days and worked straight off the bat, thanks very much for taking the time to reply @BCBuizer