Answered

Extract values from a multiple choice list simply don't work

(0) Share

Report

Posted on by UweGrunewald

Dear community,

I did spend hours today to extract the individual values of a multiple-choice SharePoint list column - reading all articles on the topic in this forum and following all hints from "AI". None of the described solutions work for me.

I have an unspectacular list where the respective column returns the below JSON, once referenced in an E-Mail e.g.

Is anyone willing/able to describe what I could do to get a string

"Domain, Website, MS365"? from that JSON.

I do now have a year experience with PA, but this issue drives me crazy.

Any hint welcome. I would even pay for support time via Teams.

[

 {

 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

 "Id": 0,

 "Value": "Domain"

 },

 {

 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

 "Id": 1,

 "Value": "Website"

 },

 {

 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

 "Id": 2,

 "Value": "MS365"

 }

]

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
I'm not sure if you are working with a single list item or multiple. Here's an example that gets a single list item and joins the Countries Multiple Choice values into a comma separated string.

The list item for this example is below.

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

Get item retrieves my list item.

Select uses Countries for the From and Countries Value for the Map. Note that I've also used Text mode so I get a simple array of countries.

Join uses the output from Select and joins with ", ".

After running the flow, Join would have the value below.

Instead of using the Join action, you could alternatively just use the join expression as shown below.

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

Was this reply helpful? Yes No
UweGrunewald 56 on at

Like (1)

Report
Copy link

Link copied!

Wow, you saved my day. A million thanks. The secret was to map from the JSON-string to the value, whereas it was tricky to insert the value in Textmode in the Select action, as ist enforced an "Apply to Each" action. Anyway, it works and I don't know how to thank you. Do you have a "buy me a cup of coffee kind" of thing?

Was this reply helpful? Yes No