How can to fetch user assigned assets in the SCTASK description?

Jesus Nava · ‎09-12-2022

Hello experts, please I need your help, I am creating a flow so that when a user is terminated, it executes, I already created the REQ, RITM and SCTASK and triggers fine, but I need to fetch for the user's assigned assets and add the info to the sctask and RITM description, here is what I have so far:

I have the Trigger, and the 3 records created, I need to add the description and in there add the user assets assigned, could you guide me on how to do it?

Thank you!

Rick62 · ‎09-12-2022

Jesus,

I would recommend you setup a related list between the Asset table and the User table, then you'll have access to all the information about the Asset and links to the records instead of just a string of the names.

If you still want to add them to the Task then you'll need to do a look up records action and create a string variable. The table will be your asset table and condition will be assigned to the trigger user (terminated user). You would then use a for each loop to update the variable then use the variable to populate the Task when it's created.

Rick

P.S. You might want to change step 3 to the "Create Task" action instead of "Create Record"

View solution in original post

Jesus Nava · ‎09-13-2022

Hello Rick,

Based on your idea, I added the look up records and a for each item, created the variable and from there the task record, and worked the way I was looking for, thank you!!!

PyLaRue · ‎01-26-2023

How and where do you create the variable after the look up Records? I'm trying to do the same and I cant figured it out.

Thank you! 🙂

ricker · ‎09-15-2022

That's the look up step right? In your step that adds the CI it looks like you used the CI (configuration item) data pill. You need to expand it and get the name pill from inside the CI data pill.

karan15 · ‎07-17-2024

am trying to create something similar , can you please provide full flow ? as in trigger as well ?

ricker · ‎09-15-2022

Great! Glad you got it working!