web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract array value fr...
Power Automate
Answered

Extract array value from a Select function, removing quotes and brackets

(0) ShareShare
ReportReport
Posted on by 42

Hi I need to extract an array value which is the output of a Select operation.

 

Here's the Select output:

 

[
  {
    "@odata.etag": "\"2\"",
    "ItemInternalId": "2",
    "ID": 21,
    "Title": "Submission Fault",
    "Person": {
      "@odata.type": "#Microsoft.Azure",
      "Claims": "i:0#.f|membership",
    },
    "Semester": "Input Faults",
    "EngineeringStatus": "Exported",          
    "Author": {
      "@odata.type": "#Microsoft.Azure",
      "Claims": "i:0#.f|membership"
    },
    "Author#Claims": "i:0#.f|membership",
    "Editor": {
      "@odata.type": "#Microsoftr",
      "Claims": "i:0#.f|membership",
      "Picture": ""
    }
  }
]
 
The key I need to target is the "EngineeringStatus" key, which only appears in the 2nd record in the array. 
I need the value only.
I tried a Compose with expression: outputs('Select'), but this returns object:
 
[
  "Exported"
]
 
I need: Exported
 
Thanks
Categories:
I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @miketurnertech 

     

    You need to write an expression to get the required value. Expression needs to be entered in the expression box as show below:

    ManishSolanki_0-1699095887427.png

    first(body('Select'))?['EngineeringStatus']

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

  • JW-17101720-0 Profile Picture
    42 on at

    Thanks @ManishSolanki  that worked great!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard