cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yurialmeida5
Regular Visitor

Stored Procedure Flow Execution Returns Boolean and not Record Object

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
yurialmeida5
Regular Visitor

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 

View solution in original post

1 REPLY 1
yurialmeida5
Regular Visitor

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 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

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.

<
Top Solution Authors
Users online (2,574)