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

(0) Share

Report

Posted on by Spencer

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Krishna92 Microsoft Employee on at

Like (0)

Report

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

@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.

Was this reply helpful? Yes No
Spencer 83 on at

Like (0)

Report

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

@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.

Was this reply helpful? Yes No
Krishna92 Microsoft Employee on at

Like (0)

Report

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

@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

Was this reply helpful? Yes No
Spencer 83 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Verified answer

Spencer 83 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
WouterV 12 on at

Like (0)

Report

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

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).

Was this reply helpful? Yes No
WouterV 12 on at

Like (1)

Report

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

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.

Was this reply helpful? Yes No