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.