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

Announcements

News and Announcements icon
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
    Manish Solanki Profile Picture
    15,167 Moderator 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard