> 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/actions/data-manipulation-and-transformation/sobject-collection-join.md).

# SObject Collection Join

## Overview

This action lets you combine text values from a collection of Salesforce records (SObjects) into a single text string. You can specify a field from your records, a delimiter to separate the values, and options for enclosing and escaping special characters.

***

## How it Helps

Imagine you have a collection of Accounts and want to create a comma-separated list of their names. This action makes it easy to extract the "Name" field from each Account record and join them into a single text string like "Account A, Account B, Account C".

***

## When to Use It

This action is ideal for:

* **Creating lists or summaries of data from your records.**
* **Formatting data for display or export.**
* **Preparing data for use in other flow elements or integrations.**
* **Avoiding manual string manipulation with formulas or code.**

***

## Example

To create a comma-separated list of Contact names:

1. **Retrieve Contacts:** Use a "Get Records" element to fetch a collection of Contact records.
2. **Configure the Action:** Select the Contact collection, specify "FirstName" as the field name, and use a comma (",") as the delimiter.
3. **Store the Result:** Store the output in a Text variable to use in your flow.

***

## Key Considerations

* **Source Collection:** Ensure you have a valid collection of SObjects.
* **Field Name:** Choose the field that contains the text values you want to join.
* **Delimiter:** Select a delimiter to separate the joined values (e.g., comma, space, newline).
* **Enclose:** Optionally enclose each value in characters like quotes (").
* **Escape Character:** Specify an escape character to handle special characters within the values.
* **Distinct:** Choose whether to include only distinct values in the joined string


---

# 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.avonnicomponents.com/flow/actions/data-manipulation-and-transformation/sobject-collection-join.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.