Flow Designer Look up record by table name

Rafał Rataj
Tera Contributor

Hi, 

 

I have an issue with look up record action on task table, in some cases it returns 'record not found' 

I see a possible solution is to use the dedicated table instead of the task table

as the trigger is the sys_attachment table there is no reference to the record table but there is the record table name 

 

the look up records requires the table type and is not working with table name (string type)

I tried a custom action but there is no 'table' output as well 

 

any suggestions?

 

Rafa_Rataj_0-1718265504551.png

 

6 REPLIES 6

Slava Savitsky
Giga Sage

Before making any changes to the flow, it makes sense to try to understand the cause of the issue. It is only understanding the nature of the problem that you can come up with an appropriate solution.

 

What attribute(s) of the target record are you using for your lookup? What are some examples of records for which the lookup works and for which it doesn't work?

Maik Skoddow
Tera Patron
Tera Patron

I tried the same and it seems that there is a bug in the "Look up Record" action as it is not possible to set table name and record Sys ID via inline script.

As a workaround, you can create a simple Flow Action which takes the table name and the Sys ID as input parameters and returns a GlideRecord instance.

You could return the GlideRecord instance within the inline script without creating a new flow action

Okay, and where/how? I'm curious.