How to pass value of Look select box from record Producer

[pandeyved]

Hi All,

I need guidance on passing value to lookup select box type value from Flow designer to submit a record producer.

I am trying to create a Subflow to submit a record producer, I have some field on record producer which is of type lookup slect box, which is coming as choice type in Flow Designer. Now if I am passing the sysid of values, then also it is returning error and If I am passing display value of answer then also , same error Values are missing.

Kindly guide, how can I fix this issue.
Thanks

[Sumanth16]

Hi @pandeyved ,

You can't get display values for select box choices in Flow designer and you have to look them up in the script

Please refer to below thread:

https://www.servicenow.com/community/developer-forum/how-to-get-display-value-of-select-box-variable...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0960074

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[pandeyved]

Hi @Sumanth16 
Thanks for the quick response. Actually my requirement is
I am using Record Producer Action which will submit one request of record producer. So on that some fields are of type lookup select box. And those variables are coming as choice field in Flow Designer. So as input if I am giving the display value of choice it is not excepting.
SS: Yellow highlighted part is Lookup select box in record producer but here appearing as choice. So how to give values to it to test?

Even I am truing to drag choice type field in it then also, it is denying

Thanks In advance.

[Community Alums]

@pandeyved 

When dealing with lookup select boxes (reference fields) in ServiceNow's Flow Designer, especially when submitting a record producer that includes such fields, the key is to ensure that the values being passed are correctly formatted and match the expected input for those fields. Lookup select boxes typically expect a sys_id of the record they reference, but how this value is passed in Flow Designer can sometimes be tricky due to the context or the data type expectations.

Here are some steps and considerations to help you troubleshoot and fix the issue:

1. Ensure Correct Data Type and Value:

• For Lookup Select Boxes (Reference Fields): You should pass the sys_id of the record that the lookup select box references. Ensure that the sys_id is correctly formatted as a string. Even though it is technically a string, any formatting issues or incorrect sys_id values can lead to errors.

2. Use Correct Action Inputs in Flow Designer:

• When setting up your subflow or action to submit the record producer, carefully map the inputs to the action. If the field is coming as a choice type in Flow Designer but is actually a reference field in the form, you need to:
  • Ensure the input type matches the expected field type. For lookup select boxes, this would typically be a Reference (sys_id).
  • Pass the correct sys_id for the referenced record. Make sure the sys_id exists in the referenced table.

If my response has resolved your query, please consider giving it a thumbs up 👍 and marking it as the correct answer✅!

Thanks & Regards,

Sanjay Kumar

[pandeyved]

Hi @Community Alums , Thanks for response.
I have defined the input as string only and I am storing correct sys_id that holds the reference of selected choice.

But the main issue is, I am not able to add the input to lookup select box variable itself. It shows below error:

This is preventing me to give the input to the variable of record producer.
Thanks in advance for guiding.