Help Getting value from object

[zwagsz]

I'm trying to build a flow which will get value from a choice field of multiple choices. 
When the choice field gets returned it seems to be coming as an object(?)

Scenario: "When a file or item is modified > Get the Choice columns values, tehre could be up to 40 choices here. 

My issue is that I can get the values but I CANNOT REACH and or Interact with the VALUE in the Object.

The value comes out like this: 

[

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 1,

    "Value": "ACO"

  },

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 2,

    "Value": "ADE"

  },

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 4,

    "Value": "ANI"

  },

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 5,

    "Value": "BAL"

  },

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 6,

    "Value": "BOE"

  },

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 7,

    "Value": "CAR"

  }

]

I want an APPLY TO EACH scenario where  I get EACH value and can make an operation on that VALUE.

But how do I get that VALUE but how do I do this in powerautomate? 

[BCBuizer]

Hi @zwagsz ,

Selecting the Value after selecting the 'Vessel Choice' column should return an array with object values: 

@{triggerBody()?['VesselChoice/Value']}

If this doesn't work, please share the expression you are currently using to retrieve the objects for modification?

[zwagsz]

Hi, @BCBuizer 

Ok so this is the way I found it: 

But I want to get a hold of that specific VALUE. 
When you say Select do you mean something like this? 

[BCBuizer]

Hi @zwagsz ,

Selecting can be done with an action or in an expression. What I suggested was an expression, but this is my next try:

@{triggerOutputs()?['body/VesselChoice']?['Value']}

 This can be used in the Compose action to view the outcomes.

[zwagsz]

Hi @BCBuizer  

Ok I tried that but I get the expression is invalid

Any idea on formatting and or how to write this? 

@{triggerOutputs()?['body/VesselChoice']?['Value']}

[zwagsz]

Hi @BCBuizer 

I did some more testing. 
here i build a new compose, changed the column to Vessel
I tried to use the following: 

I took the vessel value as in 

In compose 2 
I choose the following query:

 outputs('Compose_xmasdinner_2')?['body/Vessel']?['Value']

I get the follwing error: 

Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'The template language expression ' outputs('Compose_xmasdinner_2')?['body/Vessel']?['Value']' cannot be evaluated because property 'body/Vessel' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

[zwagsz]

Hi @BCBuizer 

I found a way to go "deeper" in the array and filter it, but HOW can i get ONLY the value? 

Compose xmasdinner gives: 

[

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 3,

    "Value": "AID"

  },

The select gives: 

[

  {

    "Name of ent ": "AID"

  },

HOW can I get ONLY And I mean ONLY the Value of the Key Name of ent? 
I want the AID here.

Any ideas? 

[BCBuizer]

Hi @zwagsz ,

Looking at this topic, a loop should be used: https://powerusers.microsoft.com/t5/General-Power-Automate/Return-values-of-multi-choice-Sharepoint-...

In the topic the loop is used to add the values to a string, but of course you can also use an array variable and append the values to that.

[grantjenkins]

The easiest way to do this is to use a Select and extract out each of the choice values into a simple array that you can pass into your Apply to each.

Note that I've changed the Select to use Map mode so we end up with a simple array of values (not an array of objects). Select in my case uses the fields Vessel Choice for From, and Vessel Choice Value for Map.

Below is what I get as output of the Select.

And the Apply to each in this example would output each of the choices in the Select.