How do I pull table fields into a flow as data pills for comparison within the flow

[joncar84]

Good morning everyone! What I'm trying to do is tricky to explain so I'll do my best. I'm trying to get certain fields from a table into a flow as data pills so that the flow can use those fields to compare against to prevent creation of duplicate records. I'll try to explain another way with examples:

I need the "Execution ID" field from the Flow Engine Context table brought into the flow (not currently an option as a data pill)

The flow will then look at a custom table, Waiting Flow Executions, at the "Execution ID" field that I added to check and see if the records in the Flow Engine Context that it has identified already exists within the custom table. If they do not exist, they will be added.

The reason for this progression is I want to add records from the Flow Engine Context table into the custom table that have been in the Waiting state for more than two weeks, but not make duplicate records in the custom table. I'm using the Execution ID field because it is unique to each execution. We are wanting to have an automated check for flows that are in the Waiting state for more than two weeks and notify us by creating records in the custom table. 

I hope this makes sense to someone, my apologies if it's confusing. Let me know if I can clarify anything. I am using Tokyo currently.

[Asal Moezi]

Hello,

I'm not sure I understood your requirement correctly, but for what I understood, by looking up the record on Flow Engine Context table and then adding an If logic, to create record on your custom table, if the IF result IS NULL, you should be able to achieve that.

Something similar to this:

I hope this helps!

[joncar84]

I'll give this a try, but I believe from what you have here, you did understand the requirement and I think this will work. Thanks!