How to find a Flow Designer execution record that was created from a specific trigger record creation

Dave65
Tera Contributor

I have a flow that is kicked off by the creation of a Record. Is there an easy way to figure out which Flow Execution is associated which which record without having to open every execution to see if the trigger is the correct record?

I have been trying to find which table the executions are held in but I haven't had any luck.

1 ACCEPTED SOLUTION

Taranjeet Singh
Giga Expert

Check this table: sys_flow_context

On this table you can select 'Source table' , 'Source Record' and filter your data.

If my answer helped you in any way, please mark this answer as helpful and correct.

View solution in original post

3 REPLIES 3

Taranjeet Singh
Giga Expert

Check this table: sys_flow_context

On this table you can select 'Source table' , 'Source Record' and filter your data.

If my answer helped you in any way, please mark this answer as helpful and correct.

Thank you Taranjeet for you quick reply!

 

Your answer almost got me where I needed to be.
I had to add the Source Record column and filter on the Name column for the name of the Flow.

The Source Record column showed me the case record that triggered the flow ex: HR Lifecycle Events Case: HRC0010802

Unfortunately, the Source Record column can only be filtered by the Sys ID for a given record. So, you have to go back to the record to get it's sys ID. If you then filter the Source Record list on that sys ID, you will find out if the flow is still active. If the record come up, the flow is still active. If not, then the flow has completed.

Not as quick as I was hoping for but a whole lot better than trying to go through all of the executions in flow designer around the date the record was created.

 

Thanks you again for your help!

Dave65
Tera Contributor

Update

You need to show the Execution ID as well on the sys_flow_context list view.

Using the Execution ID, you can filter the list in Flow Designer of the executions for that particular flow and that will take you directly to the flow. If it doesn't show up, then it has completed but, since the sys_flow_context only has live executions, that shouldn't happen.