Format HTTP request output of previous values of a multi choice column in SharePoint

(0) Share

Report

Posted on by Ami K

15,679 Super User 2024 Season 1

Hi everyone,

I am constructing a flow to output SharePoint column changes into an Email using Reza Dorrani’s tutorial: https://www.youtube.com/watch?v=Ek4oYWPWfT0

However I am experiencing issues with multi-choice columns.

For changed values, I am receiving text in the below format:

output with characters.png

To remove the square brackets and quotation marks. I first use a Select action, and select the multi-choice field from dynamic content, and then in the Map property I enter the following expression:

item()?['Value']

item value.jpg

Then I enter the following expression to be used in the email body:

join(body('Select_|_reformat_value_proposition'),';')

This successfully strips out of the irrelevant characters.

output without characters.png

However, I am not clear how to apply the same logic to the old/previous values.

output with characters old values.jpg

Does anyone have any ideas on how to approach this? I am thinking I need to apply some sort of formatting step after the HTTP GET request?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

v-xiaochen-msft on at

Like (1)

Report
Hi @Amik ,

I made a sample for you.

join(variables('var')?['results'],';')

Best Regards,

Wearsky

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

Thank you @v-xiaochen-msft .

My present workaround is to use a replace expression to remove these characters in a Compose action after the Send an HTTP request to SharePoint. Your solution does seem like the correct direction, but I do not know how to apply it within the context of my current flow.

At present the Apply to Each action populates from the HTTP request into an array. Some of these values are not derived from multi-choice columns and therefore do not have an additional “['results']” node (see “ValueProposition” below, which exists as an array within an array).

Body:

Apply to each:

Was this reply helpful? Yes No
user_ 20 on at

Like (0)

Report

Hi, I'm also experiencing the same problem as this one. Were you able to find a solution on this? Thank you!

Was this reply helpful? Yes No