Problems getting multi choice column values in

[AB_]

Hi everyone,

We're working in getting list items transformed to a PDF. Everything is working fine, except for one field. That is a multi-choice field (called 'Betrokken radionetten bij nieuwswijziging'). In this case, we're getting for every value this output: [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":4,"Value":"Valuename"}, after that we're also getting the values we want to see, but we're also getting the above code. And we want to get rid of that code :).

Our flow is:

1. Get item

2. Initialize variable (using string and the multi choice column itself)

3. Apply to each (select the output and then choose the value of the multi choice column)

4. Compose HTML (use the variable initiated above)

5. Create file

6. Convert file using Path

All columns work fine, except the multi choice column. Any idea on what we're doing wrong? Much appreciated!

[grantjenkins · Accepted solution]

Below should get what you're looking for.

I've got a list item with 3 x countries (multi-select Choice column).

See flow below. I'll go into each of the actions.

Get item retrieves the item from the list.

Select uses Countries as the input and maps the Countries Value. Note that Map is using Text mode (see screenshot).

Join uses the output from Select and joins each value with <br> which would make them go onto a new line in your HTML table. If you just wanted to display them separated with a comma, then you could just put a comma instead of <br>. You can then use the output of the Join when building up your HTML table.

If we ran the flow, the output of our Join would be:

If you didn't want to use a Join action, you can just use a join expression which will give you the same result.

//Join the countries separated with <br>
join(body('Select'), '<br>')

//Join the countries serated with ', '
join(body('Select'), ', ')

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

[AB_]

This works perfectly! Thanks!