Look up Select Box variable in workflow studio

DebbyDebby
Tera Expert

Hello,

I could not select choice for variable type "lookup select box" in workflow studio when using a "If" condition. Has anyone encounter this issue before? Suggestions will be greatly appreciated

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@DebbyDebby 

that's OOB behavior. it won't show choices for Lookup select box variable.

Do this

1) Use Get Catalog Variables action and include that Lookup select box variable. Ensure Lookup value field = SysId for you variable

2) then use lookup on that custom table which is referred by that Lookup select box with proper filter condition

3) then use IF logic to check if the lookup action gave success or failure

Based on that you can proceed further

Something like this

AnkurBawiskar_0-1743180050258.png

 

AnkurBawiskar_1-1743180063439.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

@DebbyDebby 

that's OOB behavior. it won't show choices for Lookup select box variable.

Do this

1) Use Get Catalog Variables action and include that Lookup select box variable. Ensure Lookup value field = SysId for you variable

2) then use lookup on that custom table which is referred by that Lookup select box with proper filter condition

3) then use IF logic to check if the lookup action gave success or failure

Based on that you can proceed further

Something like this

AnkurBawiskar_0-1743180050258.png

 

AnkurBawiskar_1-1743180063439.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

DebbyDebby
Tera Expert

I don't understand the second step, could you please explain more?

@DebbyDebby 

in the 2nd step you need to perform Lookup Record on the table which is referred by that Lookup Select box.

In my case Lookup Select box was referring to sys_user so I used that in Lookup Record flow action

Share what you tried and where stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader