How to set dynamic table name in look up record action in flow designer

SwarnadeepNandy
Mega Sage

How do I set a dynamic table name in a look up record, so that I can set conditions?

I can imagine, it's difficult to make fields available without the table name, but atleast metadata fields could be made available. For eg: sys_id.

Screenshot 2023-08-03 at 12.56.35 AM.png

Even after putting some encoded query in the conditions, I am unable to select the record for further processing.

2 REPLIES 2

DanielCordick
Mega Patron
Mega Patron

You may need to create your own action that accepts a table as a input. You can then decide what you want to receive back depending on the table that was used as an input. 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response helped in any way

 

Paul Kunze
Tera Guru

Hi, you can use an Encoded Query for the conditions (as you already did). It could be either from a variable or via script:

PaulKunze_0-1753945039787.png

 

It is true that the resulting record cannot be used as a data pill for the following Actions.

My workaround was a custom Action that accepts a table name and sys_id, contains a script step which creates a GlideRecord, and performs the action I need.

 

PaulKunze_1-1753946387994.png

PaulKunze_2-1753946845096.png