flow returns script from Sharepoint Choice

[cboy]

I want to generate an html email in which the body contains an html table, every one of the columns that are of the 'choice' type return this (they are multi, the rest of the email looks just fine. Is there a way to remove the extra text? just want to keep the values.

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"NEO"}][{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"EHR PHP"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"EHR SQL"}][{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"EHR PHP"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"EHR SQL"}][{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"NEO"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"NEO SQL"}]

[jake]

Try writing those values to an array variable first, and then using a Split expression on that variable inside the body of your email.

[v-yamao-msft · Accepted solution]

Hi @cboy ,

Please try with the following code to get the return results:

concat(first(item()?['Mchoice'])?['value'],';',first(skip(item()?['MChoice'],1))?['value'])

I have configured the flow likes below, and the return results:

Best regards,

Mabel

[cboy]

This worked perfectly and as expected, thanks!

---

@v-yamao-msft wrote:

Hi @cboy ,

Please try with the following code to get the return results:

concat(first(item()?['Mchoice'])?['value'],';',first(skip(item()?['MChoice'],1))?['value'])

I have configured the flow likes below, and the return results:

Best regards,

Mabel

---