Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Lookup Select Box variable on Flow Designer

Dariussiriuse
Tera Contributor

Hi everyone!

I am finding myself into a situation where I have a table with simple fields {name | number | sys_id}.

I created a catalog item that has a Lookup Select Box to get the values from that table.

 

Moving forwards, I created a flow to handle the submission of this request.

 

My issue is that when I pull in the variables from the catalog, the variable in question is of type 'choice' but displays no values inside of it? So, on a condition of 'if (get catalog variables -> var1)  |  is  |  --none--' , the '--none--' will have no other choices to select. 

I tested as well a copy of itself using only a Select Box, but my issue with this is that on the Catalog Item, I can't bring the table where the records are for choice, and therefore I have no choices displayed (unless I create those choices manually onto that variable configuration page). But I don't want this, I need the user to be able to input those new choices via record. And the Lookup Select Box is perfect for this!

But yeah.. I can't get the choices onto the flow.

Any ideas how I can make them appear?

regards,

Darius

1 ACCEPTED SOLUTION
9 REPLIES 9

Dariussiriuse
Tera Contributor

Absolutely!

So, the field that I want to show the choices for is configured as as Lookup Select Box

1.1.png

 And as you can see bellow, I  am managing to get the records as choices.

1.2.png

 BUT, my issue is that on the flow designer, those record choices are not present.

1.png

What I was saying was that I the only kind of field that does show a choice in the flow designer is the standard 'Select Box', but I need to use the Lookup Select Box specifically...

 

Hope this helps in clarifying!

Dariussiriuse
Tera Contributor

And as I was saying, I have created an action to debug the value that is passed on, but turns out that the value is 'undefined'

RichardE
Tera Expert

Community Alums
Not applicable

Hi Darius, 

I had face the same issue, my workaround  was by building a new action to update the lookup selected box. 

1. create and action with Input 

a. requested Item 

b. variable name

c. new value

2, look Up Record 

table: variable Ownership

condition Parent item is action a (requested item) and Dependent item. Question. Name is Action b (varaible name)

3. look Up Record

table : options [sc_item_option]

condition Sys ID is step2. variable ownership record.Dependent Item.sys id.

4. update record 

table options [sc_item_option]

value is step1 new value.

..... 

call the action from the flow after submit catalog Item request example f you have 3 lookup select box you need to call it 3 time. 

 

Thank you 

Mark