Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Extracting values from an OData response and formatting my current response to be JSON Array?

Hi All,

I am trying to build a flow and copy/move a Sharepoint list item from one SharePoint list to another.


The issue I am having is copying/moving the data that is in choice/multi select format.


When I look at the output from the ‘Get Items’ action, the multi select data is brought back as “@odata.type”



Having looked at a similar issue and response provided by @DeepakS


Solved: Retrieve checkbox value and remove "@odata.type" - Power Platform Community (


I have managed to retrieve the value using the following:



This has returned the output:



I now need to get this data into a multi select/choice format before I can create it in the new SharePoint list.


I know that I need to format my output as a JSON Array but I am unsure as to the steps.


I would really appreciate any assistance.

Thank you.

Dual Super User II
Dual Super User II

Hi @milanb ,


Not exactly your use case but updating SharePoint multiple choice column from flow -


If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Reza Dorrani, MVP

Hi @RezaDorrani


Thank you for the guidance.


I have managed to get to a point now where I can convert the output into an array, however, when I retrieved the values from "@odata.type":"#Microsoft.Azure…..”, I was unable to values together as a string


i.e. [“Local to your home”,”Regionally”,”Nationally”]


I could only get the outputs as individual strings (see below) I would get have to select ‘Next’ to select the view the next output.






I need to be able to create an array


  "Local to your home",





And then to get the following output via the Select




    "Value": "Local to your home"



    "Value": "Regionally"



    "Value": "Nationally"


Instead of the above, I get the following from my select:




I have tried using the join() array function and Parse JSON without luck. Perhaps I am using it in the wrong place?


Below are the steps I have used



Helpful resources

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (91,284)