Explore Plans
Mobile menu Close menu
Microsoft SharePoint

Find an item in a list

Pro plus icon This query returns an item from the SharePoint list you choose, matched by a column value.

Developer info

API endpoint slug
sharepoint.find_item_in_list
Runtime method
performQuery("sharepoint.find_item_in_list"}

Query fields

Match column Dropdown list

Label
Which list and column to match on?
Helper text
Choose the list and the column to match against, such as Title or a reference number.
Slug
match_column
Required
true
Can have default value
false

Match value Text input > Title

Label
What value to look for?
Helper text
The value to find, e.g. the title or reference number of the item.
Slug
match_value
Required
true
Can have default value
true

Ingredients

Item

Slug
item_id
Filter code
Sharepoint.findItemInList.ItemId
Type
String
Example
42

Item title

Slug
item_title
Filter code
Sharepoint.findItemInList.ItemTitle
Type
String
Example
New vendor onboarding

Matched value

Slug
matched_value
Filter code
Sharepoint.findItemInList.MatchedValue
Type
String
Example
REF-1042

Item url

Slug
item_url
Filter code
Sharepoint.findItemInList.ItemUrl
Type
Web URL
Example
https://contoso.sharepoint.com/sites/Marketing/Lists/Requests/DispForm.aspx?ID=42

Created by

Slug
created_by
Filter code
Sharepoint.findItemInList.CreatedBy
Type
String
Example
Jane Doe

Last modified at

Slug
last_modified_at
Filter code
Sharepoint.findItemInList.LastModifiedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06+05:00