How to set the approval based on choice selection from catalog variable in flow designer?

[Deepika61]

Hi All,

Actually i am facing an issue, i have one "Look up select box" variable(Which software) , so when user submitted request  with one of choice value (Lightroom, Canva, ShutterStock), then we need to send an approval to Manager .

So here i have created flow a, using "Get Catalog Variables" i get the variables , but in if condition i am trying to get choices but it shows empty

Please help me to achieve this 

Thanks

Deepika

[Ankur Bawiskar]

@Deepika61 

seems this is a platform bug.

Below gif confirms that we are unable to get the value from lookup select box variable

Workaround is

1) create a flow variable

2) set that flow variable with the value of that lookup select box variable

3) then use IF flow logic to check and compare with the sysId or whatever is the Lookup value field configured.

Example: if lookup select box is referring to sys_user table and I have given name as Lookup value then it will give the user's name. Use that in comparison.

If you give sysId then compare sysId

Below is the output with the working solution and I am able to compare the value

I hope I have answered your question.

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

[Ankur Bawiskar]

@Deepika61 

Hope you are doing good.

Did my reply answer your question?

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

[Runjay Patel]

HI @Deepika61 ,

I checked in my PDI seems value is not coming for selection. Whats your business requirement, may be i can propose some alternative. You may use lookup record activity.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Deepika61]

@Runjay Patel 

Basically my requirement was on the look up field we have many  choice values in that, so if  when user submitted request  with one of these choice values (Lightroom, Canva, ShutterStock), then we need to send an approval to Manager .

[Runjay Patel]

Hi @Deepika61 ,

Alternative i would sugusst you to add three flow variables and use in if condition with or operation.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------