{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":4252,"path":"build-workflows/workflow-studio/lookup-record-flow-designer.md","title":"Look Up Record action","bundle":null,"doc_type":null,"release":"australia","body":"\n# Look Up Record action\n\nLook up a record from any table based on defined conditions.\n\n## Roles and availability\n\nAvailable as a Workflow Studio ServiceNow core action. Users with the flow\\_designer or admin role can add an action to a flow and define configuration details.\n\n## Fields\n\n<table id=\"table_fdl_yhf_kcb\"><thead><tr><th>\n\nField\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nTable\n\n</td><td>\n\nSelect a table from the list.\n\n</td></tr><tr><td>\n\nConditions\n\n</td><td>\n\nConditions the returned record must meet.\n\n 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-&gt;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-&gt;incident record-&gt;Caller-&gt;Sys ID\\]**.\n\n</td></tr><tr><td>\n\nOrder by\n\n</td><td>\n\nDetermines how to sort results when more than one record matches the defined conditions. Select the field you want to use to sort results.\n\n</td></tr><tr><td>\n\nSort Type\n\n</td><td>\n\nSelect whether to sort alphabetically in ascending or descending order.\n\n</td></tr><tr><td>\n\nIf multiple records are found\n\n</td><td>\n\nDetermines what information to return when more than one record matches the defined conditions. -   Return only the first record\n-   Fail the step\n\n</td></tr><tr><td>\n\nDon't fail on error\n\n</td><td>\n\nDetermines whether to fail the flow when the lookup can't find a record.\n\n</td></tr></tbody>\n</table>## Outputs\n\nThese outputs appear in the Data panel. You can use them as inputs elsewhere in your flow.\n\n-   **Record**\n\n    Data type: **Record**\n\n    Record found based on the conditions you specified in the **Conditions** input.\n\n-   **Table**\n\n    Data type: **Table**\n\n    Name of the table associated with the returned record.\n\n-   **Status**\n\n    Data type: **Choice**\n\n    0 if a record was found successfully, and 1 if there was an error.\n\n-   **Error Message**\n\n    Data type: **String**\n\n    Message containing details about why the record could not be found.\n\n    **Note:** This output's value is only populated if the **Status** output's value is 1.\n\n\n## Example\n\n\\[Omitted image \"flow-example-look-up-record.png\"\\] Alt text: Example Look Up Record action in a flow.\n\n**Parent Topic:**[Workflow Studio actions](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/build-workflows/workflow-studio/flow-actions.md)\n\n"}}