Answered

flow returns script from Sharepoint Choice

(0) Share

Report

Posted on by 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"}]

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

jakeMannion 146 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
cboy 9 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No