Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.

Look Up Record action

Log in to subscribe to topics and get notified when content changes.

Look Up Record action

Look up a record from any table based on defined conditions.

Roles and availability

  • Available as a Flow Designer core action. Users with the flow_designer role can add an action to a flow and define configuration details.

Fields

Field Description
Table Select a table from the list.
Conditions

Conditions to be met by the returned record.

When building a condition that looks up the value of a reference field, use a data pill that explicitly provides the Sys ID value. Ensure the condition has the format [reference field][is][Reference type data pill->Sys ID]. For example, both the Change and Incident tables contain a reference field to the User table. To look up change records where the requester is the caller from an incident record, create the condition [Requested by][is][Trigger->incident record->Caller->Sys ID].

Order by Determines how to sort results when more than one record matches the defined conditions. Select the field you want to use to sort results.
Sort Type Select whether to sort alphabetically in ascending or descending order.
If multiple records are found Determines what is returned if more than one record matches the defined conditions.
  • Return only the first record
  • Fail the step

Example

Example Look Up Record action in a flow.

Feedback