Flow Designer Look up record by table name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 12:37 AM - edited 06-13-2024 01:01 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 06:12 AM
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?
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 07:05 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 07:17 AM
You could return the GlideRecord instance within the inline script without creating a new flow action
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 07:19 AM
Okay, and where/how? I'm curious.