# Approval using a Lookup Table

### Get the approver details **from a Lookup Table**

In this method, you can select the approvers based on rules, by looking up data from another table.

<figure><img src="/files/5gUnSjRJRNbPtnSSaFyk" alt=""><figcaption><p>Users that meet rules from a lookup table</p></figcaption></figure>

&#x20;The options are explained below:

* **Lookup Table**: This dropdown menu displays a list of tables in the connection. Select the table from which the approvers list is to be looked up/fetched.
* **Column Containing Approvers**: Choose the column containing the approvers' email IDs.

<figure><img src="/files/LnJrg5am7ObssLn5M0Z2" alt=""><figcaption><p>Lookup table details</p></figcaption></figure>

The next step is to map the matching columns from the lookup table to their corresponding columns in the source table to join the tables.

* **Source Table Column to apply filter:** Select the column from the source table that is also present in  the lookup table.
* **Matching Lookup Table Column:** Map the matching column from the lookup table.
* You can set multiple conditions (join multiple shared columns) as needed, by clicking on **Add Condition.**

<figure><img src="/files/dWUsatLKzHPfbijvrOrJ" alt=""><figcaption><p>Filter conditions</p></figcaption></figure>

In the above example, each subcategory in the lookup table has a person-in-change with their Email IDs added in the 'Approvers' column. By mapping the subcategory name columns from both tables, we allow the approvers' email IDs to be fetched for each subcategory.&#x20;

* **Default Approvers**: Specify the default approvers to approve changes that do not involve the above-set conditions (subcategories with no approver details). Click **Save.**

<figure><img src="/files/iH7Q4Ez6yknAPOiKwRas" alt=""><figcaption><p>Default approvers</p></figcaption></figure>

* Click on **Preview Rules** to view the approvers list for each subcategory.&#x20;
* You can use the **Sync Rules** option to sync the connected lookup table to fetch the latest data. The last sync details and the status can also be seen.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.powertable.com/explore-powertable/approval-flow/approval-using-a-lookup-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.