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

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

Deepika61 — Tue, 04 Feb 2025 11:22:17 GMT

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

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

Runjay Patel — Tue, 04 Feb 2025 11:38:22 GMT

Hi @Deepika61,

Make sure you have choice values created on attribute.

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

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

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

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

Badrinarayan — Tue, 04 Feb 2025 11:44:44 GMT

Hi @Deepika61,

To access the "Choices" variable, please ensure you have selected all the required variables from the available options in the bucket.

Once you've selected the variables, try accessing them within the loop. Then, based on your conditions, determine where the approval needs to be sent according to the chosen options.

If your issue is resolved, please mark my solution as helpful.

Thanks and regards,
Badrinarayan

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

Ankur Bawiskar — Tue, 04 Feb 2025 11:48:36 GMT

@Deepika61

that lookup select box is referring to which table?

share the variable configuration screenshot.

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

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

Deepika61 — Tue, 04 Feb 2025 11:51:28 GMT

@Badrinarayan @Runjay Patel

Thanks for the response, i did the same but it showing empty, Actually it is "Look Up Select Box" field ,

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

Deepika61 — Tue, 04 Feb 2025 11:53:32 GMT

@Ankur Bawiskar

Actually it is "Look Up Select Box" field ,

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

Runjay Patel — Tue, 04 Feb 2025 11:55:37 GMT

Hi @Deepika61 ,

Hope your lookup table have at least one record.

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

Ankur Bawiskar — Tue, 04 Feb 2025 11:55:39 GMT

@Deepika61

In the lookup select box configuration, give some field name in Lookup label field and then see

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

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

Ankur Bawiskar — Tue, 04 Feb 2025 12:01:46 GMT

@Deepika61

that table seems to be a custom table

Does that table have a field marked as Display=true on it?

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

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

Runjay Patel — Tue, 04 Feb 2025 12:04:47 GMT

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

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

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

Deepika61 — Tue, 04 Feb 2025 12:10:33 GMT

@Ankur Bawiskar

If i give any name in that field, on the Catalog form page , it shows all, choices as 'null"

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

Deepika61 — Tue, 04 Feb 2025 12:15:55 GMT

@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 .

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

Runjay Patel — Tue, 04 Feb 2025 12:23:08 GMT

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

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

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

Deepika61 — Tue, 04 Feb 2025 12:28:06 GMT

@Runjay Patel

Can you please explain clearly, what we need to definfe flow variables?

Thanks

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

Runjay Patel — Tue, 04 Feb 2025 12:30:14 GMT

Define sysid of all three value which you are referring: Lightroom, Canva, ShutterStock

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

Deepika61 — Tue, 04 Feb 2025 12:31:59 GMT

@Runjay Patel

But here i am unable to select anything

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

Ankur Bawiskar — Tue, 04 Feb 2025 12:33:10 GMT

@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.

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

Ankur Bawiskar — Tue, 04 Feb 2025 12:59:11 GMT

@Deepika61

you didn't create the flow variable correctly.

steps below

1) click on 3 dots and click Flow variables

2) then create new one using + icon

Did you get a chance to check the workaround I shared?

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

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

Ankur Bawiskar — Tue, 04 Feb 2025 15:01:15 GMT

@Deepika61

any update to this?

Did my earlier workaround work for you?

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

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

Runjay Patel — Tue, 04 Feb 2025 15:34:37 GMT

Hi @Deepika61 ,

@Ankur Bawiskar has suggested the steps to create flow variable, follow the steps and put it in if condition.