Type Choice is not updating the record in the workflow

ricobuenvia
Tera Contributor

Hi everyone,

I’m encountering an issue while updating a record in the cmdb_ci_service table. Most fields update correctly, but the Owned By and Business Criticality fields are not updating as expected.

It seems like the issue might be related to their field types—Owned By is a choice field, and Business Criticality is a choice field.

Can someone guide me on how to properly update these types of fields? I've attached an image below for reference.

Thanks in advance!

1 ACCEPTED SOLUTION

@ricobuenvia 

you should make Owned by variable as Reference to sys_user and auto population will still work if you select the correct dot walked field

Then you should not have any issue in setting that field in flow

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

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

View solution in original post

10 REPLIES 10

Eshwar Reddy
Kilo Sage

Hi @ricobuenvia 

Could you please provide more details?
Like what error you're getting and the flow log.

Thanks
Esh

Hi @Eshwar Reddy, Please see the image below. I tested my flow, and all the processes show as successful.

Ankur Bawiskar
Tera Patron

@ricobuenvia 

Did you print what value it holds?

Owned by on cmdb_ci_service is reference but it's Lookup Multi choice in your catalog item and hence it's not setting

Business criticality is drop down in cmdb_ci_service, did you check what value came in your flow for that variable?

Try to print that in log in your flow designer and set the value accordingly

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

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

Ankur Bawiskar
Tera Patron

@ricobuenvia 

If owned by is returning the Name of that user, then you will have to use Lookup Record on sys_user with this name and then set it in field value while setting it.

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

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