Skip to main content
Finds one item in a list by a computed key. Think of it as a “find first” with a mapping-source editor on both sides: you describe where the list lives, how to compute a key per item, and what value to match against — the first item whose key equals the match value is written to an assign. Good for “swap an employee_no for the full employee record”, or “find the EmployeeMapping for a specific system integration”.

​
Configuration

  • List source — where the list lives (usually an Assign of a previously-loaded list).
  • Key source — how to compute each item’s key. Resolved against a single binding named item holding the current list element — use Extract with key item and a path, or Dated property with key item for dated-property fields like employee_no so the canonical facade kicks in.
  • Match source — the value to compare keys against. Resolved against normal assigns.
  • Output assign — where the found item (or nil on miss) is written.
  • On miss — Set to nil (default) writes nil and continues; Halt flow stops the run with an error.

​
Tips

  • Iterating? Put the FlowLookup inside a FlowEach to swap keys for full records per item.
  • For two-level drilling (employee → mapping → external_id), chain two FlowLookups plus a FlowCompose to pluck the final field.

​
Ports