web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Stored Procedure i...
Power Automate
Answered

SQL Stored Procedure is Not Returning JSON to Power Apps

(0) ShareShare
ReportReport
Posted on by 514

I am returning 3 columns of data from a stored procedure.

The JSON Is coming back, but I cannot seem to get it into a Power Apps collection.

The collection just shows an Items and a Type column with no data.

 

For the body expression I used

 

{
   "type": "array",
    "items": {
        "type": "object",
        "properties": {
         
            "LoginID": {
                "type": "string"
            },
            "Surname": {
                "type": "string"
            },
            "Forename": {
                "type": "string"
            }
        },
        "required": [
            "LoginID",
            "Surname",
            "Forename"
          
        ]
    }
}
 

 

flow error.jpg

Any help appreciated

 

Thanks

Categories:
I have the same question (0)
  • Verified answer
    sienna28 Profile Picture
    514 on at

    I manged to solve it.

     

    Thanks

  • andrewraia Profile Picture
    49 on at

    how did you solve it? I am having the same issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#3
David_MA Profile Picture

David_MA 270 Super User 2025 Season 2

Last 30 days Overall leaderboard