Working on Power Automate aka Flow to retrieve result from Execute a SQL query (V2).
Wondering where is Dynamic Content for Execute a SQL query (V2) ?
Execute a SQL query (V2) response:
Add Compose action underneath and go to expressions and paste this in.
body(‘Execute_a_SQL_query_(V2)’)?[‘resultsets’][‘Table1’][0][‘Approved’]
It just work like a charm !
This post first appeared on Ben's System Center Experience. Read the original article.