Update fields in the Module table from the Systems Applications table using Flow

Alan Carvalho
Tera Contributor

Good afternoon everyone.

 

I created the u_exposto_para_internet column of the choice type containing the "Yes" and 'No" options in the cmdb_ci table. This new column as well as its choices were replicated to the u_module and u_cmdb_ci_aplication_system tables, since they are an extension of cmdb_ci. With that, I am building a Flow that updates the u_exposto_para_internet column in the u_module table with the value of that same column which is in the u_cmdb_ci_aplication_system table whenever it is updated.

The flow contains a trigger from the u_cmdb_ci_aplication_system table that is triggered when some updates are performed. Soon after, I have an Update Record action in the u_module table where I selected the Exposed to internet field (u_exposto_para_internet) and dragged the data pill from the Application and System trigger as shown below.

AlanCarvalho_0-1734722500651.png

 

The update even occurs, however, instead of selecting the "Yes" or "No" option previously registered as mentioned above, a third value of "Yes" or "No" is inserted in the field.

AlanCarvalho_1-1734722547253.png

 

1 REPLY 1

dbook
Kilo Sage

Do the choice (sys_choice)  'Value's match when is being inputted from the flow in Screenshot 1? If the Value is different this will produce the duplication of the options being displayed which is the Label of the choice. 

 

Hope this helps!