Switch not recognizing number value

  • 26 November 2019
  • 7 replies
  • 9 views
B
Badge +1

I have a workflow with a switch with 10 branches.  I'm trying to match the Shipping Point Name in List "Shipping Point" to Shipping Point selected in the form, and return the title column from the list which has numbers 1-10 of which branch the workflow should take.

5640i057BCEC798BF3380.jpg

 

The number from Title column in Shipping Point list is not being stored in the variable, and therefore isn't being passed to the switch.

5641i78D82664CCFE7524.jpg

The build string was a suggestion from another post but didn't resolve anything and can be removed

5642iDD6ACD3E971ECA1A.jpg

The send notification before the switch is to send an e-mail with the testNum variable that is supposed to be getting passed to the switch but it is blank every time.

 

Here is a view of the shipping point list. Matching Shipping Point Name with the Shipping Point from the form and return the Title number to choose the switch:

5643iBF31037F9298F1C6.jpg

7 replies

K
Badge +12

@bufkin901 ....Simply use query list action:

 

  • Query "Shipping Point" list
  • Filter "Shipping Point Name" column in Shipping Point list with Shipping Point Name (from Item Properties)
  • Assuming Shipping Point Name column in Shipping Point list has unique values:
    • In output option, check speicfy item limit and put 1
    • Get the Title field and store it in slt_Title workflow variable
  • Use this variable to configure your switch action
B
Badge +1

I followed your instructions but am still not getting a number in the test e-mail and switch is still not working. This is how I have the query list set:

5645iD977070B27EE2888.jpg

 

The workflow looks like this now. I disabled the earlier "Set Variable" and when it runs it goes through the switch but stops at the next command and doesn't use a branch:

5646i6EA40FEC6C886B9E.jpg

 

And this is workflow status but since it doesn't go down a branch I don't get an e-mail to update item in next step:

5647iACF8D426BE10B6C3.jpg

 

@kunalpatel Thank you

K
Badge +12

@bufkin901 .....I found the root cause of your issue. No need to use query list. I've tested using set variable and it worked for me...Instead of SLT variable, use integer variable to store title value. Also when using set variable...use my configuration...no need to use parselookup.....see below:

 

5648i770BDE7175D1BA1C.jpg

5649iB64F45B2EF534051.jpg

 

B
Badge +1

@kunalpatel Still having the same problem. Branch won't work:

5654iD51653ED56D949A6.jpg5655i389E6219844E5379.jpg

 

I also added a log in history list like you had to hopefully record the int_Title:

5656i6066C7BB62F086D2.jpg

 

Thank you so much for your help. I feel like it's very close

K
Badge +12

@bufkin901 ......Can you share below information?

 

  • Name of list 1 - 
  • Name of list 2 -
  • In which list you're running the workflow? - 
B
Badge +1

The list is called Shipping Point. It is the only list being used to evaluate. There is a list lookup field called Ship Point. I would like Ship Point to find the corresponding Ship Point Name and return the Title or Number column (added number to see if the title column was causing problems since its there by default)

 

5662i5A3FE605BB2306FD.jpg

K
Badge +12

@bufkin901 ....you saying that Shipping Point Name column in below screenshot is a lookup column?

 

In that case you might have to remove ID # using RegEx action

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings