web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Help Getting value fro...

Power Automate

Unanswered

Help Getting value from object

(0) Share

Report

Report

Posted on by zwagsz

24

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?

Categories:

I have the same question (0)

All responses Img

All responses (8)

Answers Img

Answers (0)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
zwagsz 24 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
zwagsz 24 on at

Like (0)

Report
Copy link

Link copied!

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']}

Was this reply helpful? Yes No
zwagsz 24 on at

Like (0)

Report
Copy link

Link copied!

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.'.

Was this reply helpful? Yes No
zwagsz 24 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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-field-in-an-email/td-p/620435

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.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation