> For the complete documentation index, see [llms.txt](https://docs.avoautomation.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avoautomation.com/avo-assure/actions/grid/verify-column-value.md).

# Verify Column Value

This is a pre-built action in Avo Assure, this action validates whether a specific value is present **in All rows** of a designated column in a table, and result is save in the dynamic variable.

### Syntax

**Input Value:** `<Column Header>;Value;Allrow(Optional)`

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td><p>Column Header</p><p>(Required)</p></td><td>The Column name which we want to search for value</td><td></td></tr><tr><td><p>Value</p><p>(Required)</p></td><td>The value which we want to search</td><td></td></tr><tr><td><p>Allrow</p><p>(Optional)</p></td><td>This is optional parameter. It will search for value in every row of the column.</td><td></td></tr></tbody></table>

{% hint style="warning" %}
**Note:**

* ALLROW/ANYROW, are not case sensitive
* In above example: Fee Events is element in our script, Verify Column Value is action name and Input value is Account Name;ABBOTT MILK;allrow. We will search for all rows in which abbott milk text is present.
  {% endhint %}

{% hint style="warning" %}
**ALLROW Pass/Fail:**

•If pass a value which is present in all rows in a column - It will pass

**•** If pass a value which is present in 1 row in a column and grid is showing only 1 row - It will pass

• If pass a value which is not present in all rows in a column - It will fail.

• If pass a value which is present in only 1 row, but rest rows have different data in a column - It will fail.

•If pass a value and grid has zero rows - It will Fail.
{% endhint %}

{% hint style="warning" %}
**ANYROW Pass/Fail:**

•If pass a value which is present in only 1 row, but rest rows have different data in a column - It will pass.

•If pass a value which is present in a column and grid is showing only 1 row - It will pass.

• If pass a value which is present in more than 1 row in a column - It will pass.

• If pass a value which is not present in any rows in a column - It will fail.

•If pass a value and grid has zero rows - It will fail.
{% endhint %}

**Output Value:**

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;Dynamic Variable>(Optional)&#x3C;Dynamic Variable>(Optional)</td><td>This variable holds the results in <strong>True</strong> and <strong>False</strong></td><td></td></tr></tbody></table>

**Example 1**

**Verifies a specific value in a table column**

The **Verify Column Value** action takes the value from the Input Value column (e.g., **Loan Type;Personal Loan)** and verifies it in the *Loan Type* column of the table. The result of the verification is stored in the **{Status}** variable, with the following possible values:

* **Ture** – if the value is found.
* **False** –if the value is not found or an error occurs

<figure><img src="/files/mXKyZQlreD6d65SBEqBr" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/0kHZIhOcgjoo8cMl8EiE" alt=""><figcaption></figcaption></figure>

**Example 2**

**Verifies that a specific value is present in all rows of the specified table column.**

The **Verify Column Value** action takes the value from the Input Value column (e.g., **Loan Type;Personal Loan;Allrow)** and verifies the **Personal Loan** value is present in all rows in the ***Loan Type*** column of the table. The result of the verification is stored in the **{Status}** variable, with the following possible values:

* **Ture** – if the value is present in all row.
* **False** –if the value is not present in all row

<figure><img src="/files/pFLhI8nPfDlhp9iZhu4k" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/0kHZIhOcgjoo8cMl8EiE" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.avoautomation.com/avo-assure/actions/grid/verify-column-value.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.