Hi, can anyone help me into this Please.
I was executing the "Execute a SQL query_(V2)".This is executing successfully but after that I want the Result Sets which contains id=1, will initialize in another variable/ that is I want only id 1 as an Output.
But ,I am not able to retrieve value of id in variable
What I tried I posted the Screenshots.
Any help or suggestions are welcome.
Thank you in Advance!!!
Accepted Solutions
@Anjali_Rani please try this
outputs('Compose')['ResultSets']['Table1'][0]['id']--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
@Anjali_Rani please try this
outputs('Compose')['ResultSets']['Table1'][0]['id']--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Helpful resources
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
A new place to submit your Ideas for Power Automate
Announcing a new way to share your feedback with the Power Automate Team.
Register for a Free Workshop
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Microsoft 365 EduCon
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.
