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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Stored Procedure Flow ...
Power Apps
Answered

Stored Procedure Flow Execution Returns Boolean and not Record Object

(0) ShareShare
ReportReport
Posted on by yurialmeida5 9

My flow works flawlessly and I get the dictionary response clear: 

yurialmeida5_0-1659533480996.png

However, when I try to get that response, it clearly states to me that the variable is not a Record, as expected, but a Boolean value.

 

yurialmeida5_1-1659533614676.png

 

 I got no idea what can be wrong in this case.

 

Categories:
Error handling
I have the same question (0)
  • Verified answer
    yurialmeida5 Profile Picture
    yurialmeida5 9 on at

    Problem Solved: 

    Be aware while you are generating your Response Body JSON Schema from Sample: 

    If your example outcome doesn't contain any data from some specific columns, the generated content should be modified manually to include them:

     

    i.e 

     

    yurialmeida5_0-1659609154768.png

     

    yurialmeida5_1-1659609530167.png

    As my example didn't contain any data from those columns, the type parameter wasn't specified. And the response couldn't be retrieved. 

    PS: Also check all the column types automatically assigned, Generating from Sample Function may also define them wrong based on the outcomes from your sample 

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans