Power Automate allows to get SharePoint items and to filter the results.
Use Quick Tips and learn how to load SharePoint records and filter that query.
Power Automate gives the opportunity to load records from SharePoint Online list and Microsoft List. Ready-to-use action Get items allow you to load additional data from SharePoint during the business process flow. If you will set up dictionaries or configuration lists you will be able to load precise records based on advanced filtering based on ODATA query.
During the implementation of the business process flow, you can create multiple SharePoint lists. Probably one list will be your master data list and additional, multiple lists will be some kind of dictionary that contains additional data. Imagine an approval matrix that is hosted in centralized SharePoint list and is managed by business users. You can dynamically load approvers from such list during the power Automate process.
In this article you will learn how to use SharePoint flow actions:
- SharePoint Get items
Load the SharePoint data using SharePoint Get item action
SharePoint action Get items allows you to load existing elements from the SharePoint list or from Microsoft List.
To get SharePoint list items you need to set:
- Site address – address of the SharePoint site e.g. https://company.sharepoint.com/sites/myteamsite. It is good to store such addresses in Variables.
- List Name – the name of the list. Using Variable for it is also recommended
When you will set up a connection to the SharePoint list, all available elements will be loaded. You will be able to use this data in the Dynamic Content section.
Filter SharePoint Get items results using Filter Query
Power Automate action SharePoint Get items returns all results from SharePoint List. To get a specific result or to filter it you can use available filtering options:
- Limit Entries to Folder – you can limit the results of the action to a specific Folder
- Filter Query – advanced filtering based to set query ODATA filter query
- Top Count – limit number of resulted records
Filter Query gives the most advanced possibility to filter the results of Power Automate SharePoint Get Items action.
Turn on Power Automate Experimental Features
To make the building filtering queries much easier I would recommend turning on Power Automate Experimental Features. To turn these features got
1. Open the Settings and select View all Power Automate settings.
2. In the Power Automate Settings turn on Experimental Features and Save changes.
When you will get back to the Get items action you will see there is a configurable possibility to set filter query.
How to use Get Items filter query with multiple conditions in Power Automate
The best answer for the multiple conditions in filter query in Get Items is using Advanced filtering of SharePoint in Get items Filter query.
Thanks to the Experimental Features you will be able to set the advanced query filters based on the configurator rather than wrote an ODATA filter query.
You will be able to set advanced filtering of SharePoint record loaded by Get items action.
Superb! You did learn how to use Power Automate to load records from SharePoint Online. Don’t stop here! Start to work with Power Platform today. Learn how to import data from Excel to SharePoint list, what Microsoft Dataverse is or how to start with Power Apps.
Power Automate allows you to load SharePoint list records and filter the items using the ODATA filter query in Get items action. Use multiple conditions in Get Items filter query.