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

@Shekhar Deshin1 

that's fine how you are auto populating

But the main thing you need to check is the Lookup when you iterate that MRVS

Use the approach I shared above.

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

Thanks Appreciate your help it is working fine with the Reference field.