web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Run SQL query in Power...

Power Apps

Answered

Run SQL query in PowerApps

(0) Share

Report

Report

Posted on by Wilder1626

89

Hi all

I got across @Mr-Dang-MSFT blog of executing a SQL query from powerapps,

https://www.youtube.com/watch?v=K_H5r0nzwy4

So far, I was able to set everything, just like the video, until I arrive at the "Response Body" field to populate. It says to add the Resultset.Table1, but it does not show in the in the dynamic content list as an option. Same in the video, it does not show. How do I add it to the body field?

Thanks again for your help.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Wilder1626 :

If you cannot get the return value of ‘Execute a SQL query’ using Dynamic content, then I suggest that you can directly call the value of ‘Execute a SQL query’ using Expression.Something like:

On your side the expression may be:

body('Execute_a_SQL_query_(V2)')?['resultsets']['Table1']

Best Regards,
Bof
Wilder1626 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Huge thanks for your help. That does it pretty good. I will now be able to continue the rest of the procedure.

Join the conversation