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
Dual Super User

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

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,253)