Recent
Recommendations
Webhooks
Service
X (Twitter)
Service
YouTube
Service
Discord
Service
Google Sheets
Service
MyQ
Service
Gmail
Service
Instagram
Service
See all results
Explore
Plans
Log in
Get started
Mobile menu
Close menu
Back
Microsoft SharePoint
Find an item in a list
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
Sharepoint.findItemInList.ItemId
Type
String
Example
42
Item title
Slug
item_title
Filter
Sharepoint.findItemInList.ItemTitle
Type
String
Example
New vendor onboarding
Matched value
Slug
matched_value
Filter
Sharepoint.findItemInList.MatchedValue
Type
String
Example
REF-1042
Item url
Slug
item_url
Filter
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
Sharepoint.findItemInList.CreatedBy
Type
String
Example
Jane Doe
Last modified at
Slug
last_modified_at
Filter
Sharepoint.findItemInList.LastModifiedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06+05:00
Applets using this Query
Post matched SharePoint item to Slack
by
Microsoft SharePoint
Send SharePoint item to SMS when you activate a scene
by
Microsoft SharePoint
Send Microsoft SharePoint item to Notifications on Button press
by
Microsoft SharePoint
Email Microsoft SharePoint item when you save a Note
by
Microsoft SharePoint