cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Spencer
Advocate II
Advocate II

Flow Execute Procedure Invalid data type for parameter 'Column Name' found. (Numeric(8,2) Type

1 ACCEPTED SOLUTION

Accepted Solutions
Spencer
Advocate II
Advocate II

This is a reply to my own post.  I put in a support ticket with the Powerapps Team and at the time they couldn't tell me why my procedure failed using the numeric data type but they suggested changing the data type to money which in my current case worked out fine because the app was just handling currency.  I was told they would get back to me with an answer for why the numeric data type was not working or a fix that would handle the data type in about two weeks so I will post the response here when I receive it.

View solution in original post

7 REPLIES 7
Krishna92
Microsoft
Microsoft

@Spencer 

 

I think the issue here is with the data type.

The value for the column Credit is not of type numeric and because of that you are experiencing the issue.

Could you please try converting the value that you are passing into Credit to  a integer format and test.

 

int(creditvalue).

 

If this information helps you, please hit the like button and mark the solution as resolved, so that it will help other users in future.

@Krishna92  Thank you for the response.  The error comes up as soon as the procedure name is selected.  This is before any data is passed to the procedure.  I posted a clip of the Credit field and it is clearly of numeric type.  I am sure it would work if I changed the data type to int (which would drop the value to the right of the decimal) but I need the numeric value because the app requires two decimal places.  Please let me know if I am missing what you are trying to tell me.  Thank you.

 

 sample4.JPGSample3.JPG

@Spencer 

 

If you want to limit the decimal points then you can limit it directly in the power apps.

You can use the formula Text(5.678,"#.#") this will return only 5.6 and you can also perform mathematical operations on this output value.

 

Let's say I have put Text(5.678,"#.#") + 5 this will return me 10.6

 

I think this procedure will help you on overcoming the issue

Where would you suggest converting the value?  This error is occurring before the Flow is even executed.  This error occurs when I am building the Flow.  I have tried converting the value inside the procedure but that causes an error because it does not match the actual data type of numeric.  The procedure runs fine when I provide the values in SQL.

Spencer
Advocate II
Advocate II

This is a reply to my own post.  I put in a support ticket with the Powerapps Team and at the time they couldn't tell me why my procedure failed using the numeric data type but they suggested changing the data type to money which in my current case worked out fine because the app was just handling currency.  I was told they would get back to me with an answer for why the numeric data type was not working or a fix that would handle the data type in about two weeks so I will post the response here when I receive it.

WouterV
Frequent Visitor

Hi @Spencer ,

I know it's been 1.5 years, but did they eventually give you more info on the numeric issues? Seems it is still an issue to use numeric data types in procedures (at least from Logic Apps).

WouterV
Frequent Visitor

If I change numeric to decimal in the sql stored procedure, then LA isn't throwing an error. As per MS documentation they're synonyms, so it's weird it's not both accepted.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,544)