> 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/get-record-from-sobject-collection.md).

# Get Record from SObject Collection

## Overview

This action allows you to easily retrieve a specific record from a collection of Salesforce records (SObjects). You can choose to get the first record, the last record, or a record at a specific index within the collection.

***

## How it Helps

Imagine you have a collection of Opportunities sorted by close date and want to identify the Opportunity that will close next. This action lets you quickly retrieve the first record from the collection, representing the Opportunity with the earliest close date.

***

## When to Use It

This action is ideal for:

* **Accessing specific records within a collection.**
* **Retrieving the first, last, or any record by its position in the collection.**
* **Simplifying record retrieval without looping or complex logic.**
* **Working with sorted collections where the order of records is important.**

***

## Example

To get the most recently created Case from a collection:

1. **Retrieve Cases:** Use a "Get Records" element to fetch a collection of Case records, sorted by "CreatedDate" in descending order.
2. **Configure the Action:** Select the Case collection and choose "First" as the operation to retrieve the first record in the collection (the most recently created).
3. **Store the Record:** Store the output in a Record variable for use in your flow.

***

## Key Considerations

* **Source Collection:** Ensure you have a valid collection of SObjects.
* **Operation:** Choose the appropriate operation:
  * **First:** Retrieves the first record in the collection.
  * **Last:** Retrieves the last record in the collection.
  * **At Index:** Retrieves the record at a specific numerical index (starting from 0).


---

# 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/get-record-from-sobject-collection.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.