Find an item in a table

The Find an item in a table helper allows you to get a certain item (also known as a row) from a table.

Common use-cases

• Getting an item matching a certain condition

• Getting an item with the lowest or highest numerical, chronological or alphabetical rank in a specified column

The helper receives a table and a condition that tells it how to choose the item, and returns the item that matches that condition.

Find an item in a table options

1. The first item

2. The last item

3. A random item

4. The item with the highest-ranked value in a column

5. The item with the lowest-ranked value in a column

6. The first item matching a condition

Keep in mind For options 4-5 a column will be specified. For option 6 a search condition will be specified.

Example 1 - Getting inventory data (quantity)

As a shop owner, you require a feature to identify the item with the highest quantity in your inventory. This will let you easily offer discounts on that item and refresh your current inventory with new items for the upcoming season.

Name	Quantity
Blue socks	23
Red shirts	45
Green shoes	67
Yellow hats	89

Step-by-step instructions

1. Add the helper Find an item in a table

2. Map the table of inventory into the table input

3. Choose The item with the highest-ranked value in a column

4. Choose Quantity under the field Column to get item by.

5. The helper will return the row with the highest quantity:

Yellow hats	89

Example 2 - Send invites based on dates

You’re an event producer with the following data:

Name	Email	Last Contacted Date
John Doe	[e-mail]	March 15, 2023
Jane Smith	[e-mail]	February 10, 2023
Bob Johnson	[e-mail]	January 1, 2023
Alice Williams	[e-mail]	May 25, 2023
Charlie Brown	[e-mail]	April 20, 2023

Let’s say you want your feature to retrieve a list of event invites, and you need to send an invitee to the person who has been contacted first from a list.

1. Add the action Find an item in a table.

2. Map the table of invitees into the table input.

3. Choose The item with the lowest-ranked value in a column

4. Choose Last contacted date under the field Column to get item by.

5. The helper will return the row:

Bob Johnson	[e-mail]	January 1, 2023

Example 3 - Find ID of a user from a table (matching a condition)

You’re a support team manager with the following data of your team:

Team Member	Position	Employee ID	Email
David Taylor	Support Specialist	123	mailto:[e-mail]
Sophia Martin	Support Team Lead	456	mailto:[e-mail]
James Davis	Support Analyst	789	mailto:[e-mail]
Emily Wilson	Support Manager	012	mailto:[e-mail]
Henry Thompson	Customer Support Representative	345	mailto:[e-mail]

You have a feature that retrieves the ID of a user from a table of team members. You want to find the ID of the current user, using their email.

1. Add the action Find an item in a table.

2. Map the table into the table input.

3. Choose The first item matching a condition.

4. Under Rules to filter by, choose the Email column matches exactly, and map from “Runtime & user attributes” the email address of the running user.

5. The helper will return the row that matches the email.