Question

Error Converting data type nvarchar to float Workflow

Workflow

Updated December 29, 2017

asked on December 29, 2017

I have a couple of workflows that I was manually updating each type we opened a location. I have a different email being sent out based on the person assigned to the location. I have a SQL database with this information that i would like to query instead of updating each workflow. I get the error converting nvarchar to float. Anyone have ideas based on my screen shots?

SQL Mappings.jpg (100.21 KB)

| Download

Query Data.jpg (66.37 KB)

| Download

Data.jpg (28.24 KB)

| Download

Token Query.jpg (24.75 KB)

| Download

Error.jpg (55.26 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on December 29, 2017

Float is not alphanumeric, it's a number with up to 15 places after the decimal point. It looks like the SQL Data Import wizard guessed wrong and set the column type as float when it probably should've been nvarchar like the other ones.

1 0

Replies

replied on December 29, 2017

Your "Location" column is defined as a "float" data type in SQL. What value are you trying to pass in?

0 0

replied on December 29, 2017

It is an alpha numeric column that i use for dropdowns in forms, and various lookups

0 0

SELECTED ANSWER

replied on December 29, 2017

1 0

replied on December 29, 2017

OK, so i got this working. I changed location the nvarchar. I was trying to change my other column to float.

Thanks so much

0 0

You are not allowed to follow up in this post.

Question

Question

Error Converting data type nvarchar to float Workflow

Answer

Replies

Sign in to reply to this post.