Power Platform Community Forum Thread Details

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.

Categories:

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