Issues with Flow update and delete record actions

[Moedeb]

I have a catalog item that once submitted I want to update the Request field on the RITM, to associate it with the Request added.

I then want to delete the Request that was created when the catalog item was submitted (which should at that point have no RITM associated with it)

I thought this would be something fairly simple with Flow designer since there are actions to both update a record and to delete a record, but I can't get it to work.

On the catalog item I have a variable that gets the Request record that the new RITM is to be associated with later.

So in the flow I start the normal way 

Trigger - Service Catalog

Actions:

1. Get catalog variables (this gets the variable holding the Request I want to add the RITM to)

2. Lookup record - this is set to look up the current trigger request number/record

3. Update record - set to update the RITM created by the trigger and to add the Request number from the get catalog variable in action 1.

4. Delete record - set to delete the request found/stored in action 2 lookup record

So what is happening is action 3 - Update record is stripping out the Request field value, but not replacing it with anything and action 4 is not deleting anything either.

The execution details show 3. Update record as Request= (nothing) and 4. Delete record is blank.

I've attached the execution details screen shot and the current flow for better understanding.

If you can help I'd appreciate it.

[Amit Verma · Accepted solution]

Hi @Moedeb 

Instead of Request Number, pass the new request sys_id and retry.

Thanks and Regards

Amit Verma

[Moedeb]

Thanks @Amit Verma , I have managed to get it working. I had actually tried the sys_id previously, but now I tried by dot walking from the RITM to the Request sys_id, where as last time I went more directly.

Either way it is now working. Thank you for your help 😀