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
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

@Ankur Bawiskar 

 

Could you please help me on how to get the MRVS those are under variable set how to get values in flow designer same like above variable for MRVS and iterate in flow designer to update on alm_asset table.

Please suggest.

Client ask for MRVS variable set for adding asset.

 

Thanks,

Shekhar,

 

@Shekhar Deshin1 

Something like this for MRVS but please enhance

mrvs 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

Shekhar Deshin1
Mega Guru

I am also used following scripted link added :

Following solution also worked fine:

 

https://www.servicenow.com/community/developer-blog/how-to-iterate-through-a-list-collector-variable...