question Re: choice field value not showing in flow designer. in ServiceNow AI Platform forum

choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 11:51:41 GMT

I have a catalog item in that i have a multiple choice variable , i need to get the value from this variable and need to show this in cmdb resource group table in environment choice field.

How can i achieve this? Thanks in advance.

Re: choice field value not showing in flow designer.

Ankur Bawiskar — Thu, 21 Oct 2021 11:57:04 GMT

Hi,

Can you please explain with example what is required?

need to get value from this variable and show in table's choice field?

The environment choice field will already have some choices in it right

Regards
Ankur

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 12:52:38 GMT

i need to get value from catalog variables. after that one record need to be inserted in cmdb resource group table with the values in request.

I have environment variable in both catalog item and cmdb resource group table.

How can i show the environment value from catalog item to resource group table.

i need to show the environment variable value which requester submits.

The environment choice field will already have some choices in it right:YES

Re: choice field value not showing in flow designer.

Ankur Bawiskar — Thu, 21 Oct 2021 13:10:45 GMT

Hi,

so you want to set the environment field with the environment variable during insertion

I hope both the variable and field have same choice values

So where are you stuck?

How are you inserting data into that table from flow?

you can use Get Catalog Variables Action and get the variables

Then during the insert; you can use the Data pill and select the variable from the Get Catalog Variables Action

Regards
Ankur

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 13:14:57 GMT

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 13:16:34 GMT

In get catalog variables i have selected this sh_srvc_tier , but still , its showing this.

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 13:20:15 GMT

var env = fd_data.subflow_inputs.sh_srvc_tier;

if(env == 'sh_Production'){

return 'Production';

}

else if(env == 'sh_Acceptance'){

return'Acceptance';

}

else if(env == 'sh_Development'){

return'Development';

}

else if(env == 'sh_Test'){

return'Test';

}

I have tried, this script

Re: choice field value not showing in flow designer.

Ankur Bawiskar — Thu, 21 Oct 2021 13:21:09 GMT

Hi,

Please share complete screenshots.

you can use the data pills and set the value directly without using any script

Regards
Ankur

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 13:26:00 GMT

I have tried to use the data pill, but , in that i am getting the backend value like Instead of "production" , i am getting "sh_production". In Cmdb resource group table in environment field one new chioce "sh_production" added .

Re: choice field value not showing in flow designer.

Ankur Bawiskar — Thu, 21 Oct 2021 13:45:47 GMT

Hi,

that is what I mentioned; choice values should be same in both

Then using data pill it would work directly and no script is required

Regards
Ankur

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 13:45:59 GMT

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 13:48:39 GMT

one new choice is created as sh_production and that value dispalyed. I want only Production as it already there.

Choice values are different and choice name only same

Re: choice field value not showing in flow designer.

Ankur Bawiskar — Thu, 21 Oct 2021 14:25:29 GMT

Hi,

please ensure choice values are same in both variable and field

Regards
Ankur

Re: choice field value not showing in flow designer.

Nasreenfathima — Thu, 21 Oct 2021 14:37:01 GMT

Choice values are different for both. catalog variable and cmdb resource group table.

Re: choice field value not showing in flow designer.

Ankur Bawiskar — Fri, 22 Oct 2021 05:29:53 GMT

then use inline script and use if else

get the catalog variable value and compare it and return the correct choice value for that field

Regards
Ankur

Re: choice field value not showing in flow designer.

Nasreenfathima — Fri, 22 Oct 2021 06:14:02 GMT

var env = fd_data.subflow_inputs.requested_item.variables.sh_op_env_bc;

if(env == 'sh_Production'){

return 'Production';

}

else if(env == 'sh_Acceptance'){

return'Acceptance';

}

else if(env == 'sh_Development'){

return'Development';

}

else if(env == 'sh_Test'){

return'Test';

}

It worked