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

Community site session details

Session Id : gi5DcbwPHwvpDZ+yRQMSD0
Power Automate - Using Flows
Answered

How to select value from an object in an array in an object

Like (0) ShareShare
ReportReport
Posted on 2 Dec 2021 12:40:12 by 128
What is the correct way to select the value 17 from the JSON below in Power Automate?
{
  "ResultSets": { "Table1": [ { "Column1"17} ] },
  "OutputParameters": {}
}
I've tried...
    outputs('MySqlAction')?['ResultSets']['Table1'][0]['Column1'] - returns an error saying Table1 is not selectable
    outputs('MySqlAction')?['ResultSets']?['Table1'][0]?['Column1'] - no error but no value returned either.
  • Verified answer
    cymorg Profile Picture
    128 on 02 Dec 2021 at 15:46:44
    Re: How to select value from an object in an array in an object

    Found the answer myself... 

    outputs('InsertRecord')?['body/resultsets']?['Table1'][0]?['Column1']

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete