How to Auto update alm_asset fields using catalog form

Shekhar Deshin1
Mega Guru

@Ankur Bawiskar 

We have catalog item variables (Select the Assets) list collector which collect the list of assets like abc,xyz,test1

 

Then user will filled form assigned to, Managed by, Location and department for alm_asset table and these fields should auto update on alm_asset table using catalog item form how to achieve this using flow designer.

 

Whatever assets selected those should update with assigned to,managed by and department on alm_asset table.

Please suggest

Thanks,

2 ACCEPTED SOLUTIONS

Ankur Bawiskar
Tera Patron
Tera Patron

@Shekhar Deshin1 

you can use this

1) Get Catalog Variables in flow

2) then use Lookup Records on alm_asset with condition as

Sys id [IS ONE OF] Get Catalog Variables->List Collector

3) Then use For Each to iterate on Step 2 

4) Then use Update Record and set the field value

check this and enhance as per your requirement

list collector iterate.gif

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

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

View solution in original post

@Shekhar Deshin1 

the asset variable within MRVS should be Reference type

Then it gives sysId when you access it's value and then you can use that in Lookup Record with condition as SysId = ForEach->Variable

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

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

View solution in original post

11 REPLIES 11

@Ankur Bawiskar 

While adding MRVS i am getting following error in look up each item in MRVS (here i have added split with (comma ,). I have added same like List collector which initially it was working fine to update. 

 

Does this split , will work here for getting each item added from MRVS.

 

No record found in Look Up Record action. Context id: #xyzssss#, table: alm_asset, encoded query: sys_id=[object Object]

 

After this error flow not flowing ahead.

 

Thanks,

Shekhar,

@Shekhar Deshin1 

share your latest flow step screenshots

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

@Ankur Bawiskar 

You can see the attachment flow steps added.

Thanks,

@Shekhar Deshin1 

the asset variable within MRVS should be Reference type

Then it gives sysId when you access it's value and then you can use that in Lookup Record with condition as SysId = ForEach->Variable

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

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

@Ankur Bawiskar 

Thanks for your help i will try on this but i am using reference field only in MVRS.

 

I am using select_the_asset_to_update  MVRS reference field only and i am adding 

Asset tag, Serial number,Location,assinged to as single line text field (which is string).

 

Once user click on Add it will reference to alm_asset table and with the client script getreference script i am updating serial number,assinged to,asset tag in MVRS. once the user add it will list on the form then same i need to iterate in for each loop.

ShekharDeshin1_0-1745478649929.png