> For the complete documentation index, see [llms.txt](https://docs.avonnicomponents.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avonnicomponents.com/flow/tutorials/components/data-table.md).

# Data Table

Screen flow tutorials for the Avonni Data Table: show records, let users pick, edit and act on them, then use the result later in the flow.

The [Data Table](https://docs.avonnicomponents.com/flow/flow-components/data-table.md) shows Salesforce records on a flow screen, where users sort, select, edit and act on them. What they pick or change comes out as flow variables, so the next Decision, Loop or Update Records works on exactly those rows.

{% hint style="info" %}
New to the Data Table? Start with [Learn the Basics](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/learn-the-basics.md): it puts the table on a screen, feeds it your open deals and reads the selection in the next element. Every other tutorial starts from that screen.
{% endhint %}

This Short shows three things the standard flow Data Table cannot do: totals per group, badges colored by a formula, and a picklist edited in the row.

## Start

Put the table on a screen, shape its columns and use what the user picks.

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Learn the Basics</strong></td><td>Put an Avonni Data Table on a flow screen, feed it your open deals, label the columns, and use the rows the user ticks in the next flow element.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FXCfA0KwXVCMbLpTgZi2Z%2Fdata-table-tutorial-card-learn-the-basics.png?alt=media">data-table-tutorial-card-learn-the-basics.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/learn-the-basics.md">Learn the Basics</a></td></tr><tr><td><strong>Choose the right data source</strong></td><td>Decide where a screen flow Data Table gets its rows: a Get Records collection, its own Query, or typed rows, and what to do when the data comes from Apex.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2F8wbAcmLeWqgLbVVaAw5S%2Fdata-table-tutorial-card-choose-the-right-data-source.png?alt=media">data-table-tutorial-card-choose-the-right-data-source.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/choose-the-right-data-source.md">Choose the right data source</a></td></tr><tr><td><strong>Data Table editor</strong></td><td>Build and tune the columns of a screen flow Data Table right on the Component Builder preview: drag fields, rename, reorder and use each header menu.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FM3YZAAKKXbpmzECYxMkM%2Fdata-table-tutorial-card-data-table-editor.png?alt=media">data-table-tutorial-card-data-table-editor.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/data-table-editor.md">Data Table editor</a></td></tr><tr><td><strong>Work with Selected Rows</strong></td><td>Let a sales manager tick up to three deals in a screen flow Data Table, require a pick, then reassign every selected deal with one Loop and Update Records.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FuenlGdjXpM5fUS4FtT4i%2Fdata-table-tutorial-card-work-with-selected-rows.png?alt=media">data-table-tutorial-card-work-with-selected-rows.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/work-with-selected-rows.md">Work with Selected Rows</a></td></tr><tr><td><strong>Displaying Record Name field as a link</strong></td><td>Turn the record name and parent records into clickable links in a screen flow Data Table with Linkify, without formula fields or URL columns.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2F7oafdhDGB9zUGSLJY82j%2Fdata-table-tutorial-card-displaying-record-name-field-as-a-link.png?alt=media">data-table-tutorial-card-displaying-record-name-field-as-a-link.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/displaying-record-name-field-as-a-link.md">Displaying Record Name field as a link</a></td></tr></tbody></table>

## Display

Choose what each column shows, group the rows and control how a long list loads.

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Column Types Gallery</strong></td><td>See every column type of the screen flow Data Table, from progress bars and star ratings to pickers and buttons, and pick the right one for each field.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FN1XhvvfTTfShKLOHN0lX%2Fdata-table-tutorial-card-column-types-gallery.png?alt=media">data-table-tutorial-card-column-types-gallery.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/column-types-gallery.md">Column Types Gallery</a></td></tr><tr><td><strong>Group rows and show totals</strong></td><td>Group the rows of a screen flow Data Table by a field such as Stage, then add a subtotal per group and a grand total at the bottom of the table.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FPoz8s4vdVXr4kJBqhv1S%2Fdata-table-tutorial-card-group-rows-and-show-totals.png?alt=media">data-table-tutorial-card-group-rows-and-show-totals.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/group-rows-and-show-totals.md">Group rows and show totals</a></td></tr><tr><td><strong>How to add images on the Data Table</strong></td><td>Show a picture in each row of a screen flow Data Table, such as the deal owner's photo, with the Avatar column type and its type attributes.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FdOkNasaDXXyMEpAh0cek%2Fdata-table-tutorial-card-how-to-add-images-onthe-data-table.png?alt=media">data-table-tutorial-card-how-to-add-images-onthe-data-table.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/how-to-add-images-onthe-data-table.md">How to add images on the Data Table</a></td></tr><tr><td><strong>Displaying a record as a QR code</strong></td><td>Turn a field value into a scannable QR code in each row of a screen flow Data Table, for example a link that opens the opportunity on a phone.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FUgyHeONTg4E3Hsp4GlXl%2Fdata-table-tutorial-card-displaying-a-record-as-a-qr-code.png?alt=media">data-table-tutorial-card-displaying-a-record-as-a-qr-code.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/displaying-a-record-as-a-qr-code.md">Displaying a record as a QR code</a></td></tr><tr><td><strong>Handling formula text fields</strong></td><td>Display a formula text field that returns an image or a link, such as a Stage flag built with IMAGE(), as rendered content in a screen flow Data Table.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FEueh5zb1rh5J4WLaFFn8%2Fdata-table-tutorial-card-handling-formula-text-field.png?alt=media">data-table-tutorial-card-handling-formula-text-field.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/handling-formula-text-field.md">Handling formula text fields</a></td></tr><tr><td><strong>Activate infinite scrolling</strong></td><td>Load the rows of a screen flow Data Table in batches as the user scrolls, by giving the table a fixed height and leaving pagination off.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FTguA28uBWKO7Nrj2m5Ie%2Fdata-table-tutorial-card-activate-infinite-scrolling.png?alt=media">data-table-tutorial-card-activate-infinite-scrolling.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/activate-infinite-scrolling.md">Activate infinite scrolling</a></td></tr></tbody></table>

## Style

Color badges and cells, and show columns only to the users who need them.

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Customizing the Badge Color using a formula</strong></td><td>Color the Stage column of a screen flow Data Table as badges, green for won and red for lost, driven by one formula field on Opportunity.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FsUfHbIPqDtxJLl0K25gv%2Fdata-table-tutorial-card-customizing-the-badge-color-using-a-formula.png?alt=media">data-table-tutorial-card-customizing-the-badge-color-using-a-formula.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/customizing-the-badge-color-using-a-formula.md">Customizing the Badge Color using a formula</a></td></tr><tr><td><strong>How to Conditionally Color Cells</strong></td><td>Give each Stage cell of a screen flow Data Table its own background color, from one formula field that returns an SLDS class per row.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FJwvxYt0rFLXX9TSeKzzy%2Fdata-table-tutorial-card-how-to-conditionally-color-cells.png?alt=media">data-table-tutorial-card-how-to-conditionally-color-cells.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/how-to-conditionally-color-cells.md">How to Conditionally Color Cells</a></td></tr><tr><td><strong>How to Set Column Visibility</strong></td><td>Show a Data Table column only to the right users, for example the Discount column for sales managers, with a Boolean formula in your screen flow.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FppgdVdJhlaA3LnqFM52n%2Fdata-table-tutorial-card-how-to-set-column-visibity.png?alt=media">data-table-tutorial-card-how-to-set-column-visibity.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/how-to-set-column-visibity.md">How to Set Column Visibility</a></td></tr></tbody></table>

## Act

Give users menus, buttons and header actions, and hand what they click to the rest of the flow.

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Creating Row Actions</strong></td><td>Add a row menu, buttons and links to a screen flow Data Table, then open another flow, a record or the next screen with the row the user clicked.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FsohhKNGT6W3gk99MTGY8%2Fdata-table-tutorial-card-creating-row-actions.png?alt=media">data-table-tutorial-card-creating-row-actions.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/creating-row-actions.md">Creating Row Actions</a></td></tr><tr><td><strong>Column Header Actions and Default Filters</strong></td><td>Open a screen flow Data Table already filtered on the deals that matter, and add your own entry to a column header menu that the flow can act on.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FS9PDcr4pVDTg7peXR1xc%2Fdata-table-tutorial-card-column-header-actions-and-default-filters.png?alt=media">data-table-tutorial-card-column-header-actions-and-default-filters.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/column-header-actions-and-default-filters.md">Column Header Actions and Default Filters</a></td></tr><tr><td><strong>Passing multiple record IDs to another flow</strong></td><td>Let users tick several rows of the Data Table and send the selected record Ids to a second flow in one click, from a header action.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2Fd5wZj8eJog0l3o2weUYE%2Fdata-table-tutorial-card-passing-multiple-record-ids-to-another-flow.png?alt=media">data-table-tutorial-card-passing-multiple-record-ids-to-another-flow.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/passing-multiple-record-ids-to-another-flow.md">Passing multiple record IDs to another flow</a></td></tr><tr><td><strong>How to Grayscale Header Actions Dynamically in Avonni Data Table</strong></td><td>Keep the Data Table header buttons grayed out until the user ticks at least one row, with a Boolean formula bound to Disable Actions.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FRPjCR8ZIrodKUX29B1pO%2Fdata-table-tutorial-card-how-to-grayscale-header-actions-dynamically-in-avonni-data-table.png?alt=media">data-table-tutorial-card-how-to-grayscale-header-actions-dynamically-in-avonni-data-table.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/how-to-grayscale-header-actions-dynamically-in-avonni-data-table.md">How to Grayscale Header Actions Dynamically in Avonni Data Table</a></td></tr><tr><td><strong>Enabling auto-refresh on the Data Table when pressing a button</strong></td><td>Reload the rows of a screen flow Data Table from a Refresh button in its header, or on its own when a dialog flow finishes, without restarting the flow.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2F5ynpARyUDxtbZ8AvZ8pl%2Fdata-table-tutorial-card-enabling-auto-refresh-on-the-data-table-when-pressing-a-button.png?alt=media">data-table-tutorial-card-enabling-auto-refresh-on-the-data-table-when-pressing-a-button.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/enabling-auto-refresh-on-the-data-table-when-pressing-a-button.md">Enabling auto-refresh on the Data Table when pressing a button</a></td></tr></tbody></table>

## Edit and export

Change values in the table, filter long lists and download rows.

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Making a field editable</strong></td><td>Let users correct amounts, stages and close dates directly in a screen flow Data Table, then save the edits to Salesforce in one step.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2Fq6Ex9jPg062HKz0INxHV%2Fdata-table-tutorial-card-making-a-field-editable.png?alt=media">data-table-tutorial-card-making-a-field-editable.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/making-a-field-editable.md">Making a field editable</a></td></tr><tr><td><strong>Adding filters</strong></td><td>Add Stage and Owner filters to a screen flow Data Table so users narrow a long list of deals themselves, with the filters above the table or in a side panel.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FELIPTxAVE9E2QLDXdqKd%2Fdata-table-tutorial-card-adding-filters.png?alt=media">data-table-tutorial-card-adding-filters.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/adding-filters.md">Adding filters</a></td></tr><tr><td><strong>Setting up data export</strong></td><td>Add an Export button to a screen flow Data Table so users download the deals they see, the rows they selected, or everything, as Excel or CSV.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2F9DXOaDLi5PSlZzlIPtdt%2Fdata-table-tutorial-card-setting-up-data-export.png?alt=media">data-table-tutorial-card-setting-up-data-export.png</a></td><td><a href="https://docs.avonnicomponents.com/flow/tutorials/components/data-table/setting-up-data-export.md">Setting up data export</a></td></tr></tbody></table>

## Related tutorials elsewhere

* [Implementing a bulk edit on the Data Table](https://docs.avonnicomponents.com/flow/tutorials/projects/implementing-a-bulk-edit-on-the-data-table.md): change one field on many selected records in a single screen.
* [Reactive query tutorials](https://docs.avonnicomponents.com/flow/tutorials/reactive-query-tutorials.md): make the table reload when the user changes another component on the same screen, starting with [How to make Data Tables reactive](https://docs.avonnicomponents.com/flow/tutorials/reactive-query-tutorials/how-to-make-data-tables-reactive.md).
* [Filter Data Tables with multi-select comboboxes](https://docs.avonnicomponents.com/flow/tutorials/components/combobox/filter-data-tables-with-multi-select-comboboxes.md): let users pick several values in a Combobox and narrow the table to them.
* [Filter a Data Table or Map by the current record](https://docs.avonnicomponents.com/flow/tutorials/tips-and-tricks/filter-a-data-table-or-map-by-the-current-record.md): show only the rows related to the record the flow runs on.
* [Data Table reference](https://docs.avonnicomponents.com/flow/flow-components/data-table.md): every property, output variable and interaction of the component.

## Watch

Prefer video? Two walkthroughs of the Data Table in screen flows.

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Guided Tutorial by Yumi Ibrahimzade</strong></td><td>A community walkthrough of the Avonni Data Table in a screen flow, step by step.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2Fgit-blob-a51e9efaa621c10bb95c514468b21d9c1f0591db%2FDesign%20sans%20titre%20(43).png?alt=media">Design sans titre (43).png</a></td><td><a href="https://www.linkedin.com/posts/yumiibrahimzade_ad-salesforce-trailblazercommunity-activity-7208434323576827906-T2X3">https://www.linkedin.com/posts/yumiibrahimzade_ad-salesforce-trailblazercommunity-activity-7208434323576827906-T2X3</a></td></tr><tr><td><strong>7 Data Table tricks for screen flows</strong></td><td>Seven Avonni Data Table tricks for Salesforce screen flows, in one short video.</td><td><a href="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2F9KGoKlLxlCp53sQ43mmE%2Fdata-table-tutorial-card-watch-7-tips.png?alt=media">data-table-tutorial-card-watch-7-tips.png</a></td><td><a href="https://www.youtube.com/watch?v=bViQNI5RlR8">https://www.youtube.com/watch?v=bViQNI5RlR8</a></td></tr></tbody></table>


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.avonnicomponents.com/flow/tutorials/components/data-table.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
