Skip to main content

Hello all,

I am creating a workflow at the moment with nintex 2013.

In my library are multiple items filled in from different users. Most of the fields/columns are of the type choice. The users assess a document and that should be easy and fast so I thought 'choice' is the best way to do it.

The workflow is calculating a mean value and should fill in the new value in the right field in the 'Concluion item'.

I get the error Coercion Failed: Unable to transform the input lookup data into the requested type.
so it obviously doesn't work (even though the calculated result is one of the choices).

Is there a workaround? Is the 'update item' and fill into the field 'choice' process even possible?

Thank you!!

Hi

can you put some screenshots of what you are trying to achieve please?  that will allow me to mock up a replica and hopefully help you solve the issue.


Are you using a SharePoint form? If so, here is a piece of advice. It is not advisable to use choices unless they are yes/no. Lookup fields are preferable. The reason is, if you rename the choice fields you will still have those old choices with the old name and then get choices with the new name. You will not have good data. Where as a lookup uses the index of the value. That never changes. So if you change the name, it won't matter it will be same for all items using that selection. I know this wasn't part of your question but it would make your problem go away.


I thought about changing it to a lookup filed but wasn't sure. I tried it for one column, but I came across two problems
1. you can just select a library and no condition so that you would have to create a library for each column (is there another way?)
2. the choices you can pick from are not in the right order (e.g. low high medium instead of low medium high)
Am I wrong with those two points? I am still not sure if I should change choice to lookup. I have 7 columns with choice/lookup and if I want to change some things in a few months I don't want the whole items to be broken. :/


That would mean maintaining a user-friendly "sensible" order when items are changed might mean artifically deleting and re-adding rows to get them in the right order

you can define view(s) on sharepoint list and configure lookup control to use one of defined views.

using views you can effectively sort and/or filter which items and in what order are populated into lookup control


Reply