⭐ PARTNER OF THE BLOG
Microsoft 365 atWork partners with AFI.AI, the developer of modern data protection platform built from the ground up to deliver a fully-fidelity backup for MICROSOFT 365 and GOOGLE WORKSPACE.

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.

Power Automate – How to filter SharePoint Get items results

BE COPILOT READY

Sign up for the free online course that will help you and your organization prepare for the new Generative AI era..

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

Power Automate – How to filter SharePoint Get items results

 

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.

Power Automate – How to filter SharePoint Get items results

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.

Power Automate – How to filter SharePoint Get items results

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
Power Automate – How to filter SharePoint Get items results

Filter Query gives the most advanced possibility to filter the results of Power Automate SharePoint Get Items action.

Power Automate – How to filter SharePoint Get items results

BE COPILOT READY

Sign up for the free online course that will help you and your organization prepare for the new Generative AI era..

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.

Power Automate – How to filter SharePoint Get items results

2. In the Power Automate Settings turn on Experimental Features and Save changes.

Power Automate – How to filter SharePoint Get items results

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.

Power Automate – How to filter SharePoint Get items results

You will be able to set advanced filtering of SharePoint record loaded by Get items action.

What’s next?

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 listwhat Microsoft Dataverse is or how to start with Power Apps.

Not enough?

I prepared more articles that could help you get a better understanding of Power AutomatePower AppsMicrosoft Lists and SharePoint Online.

Conclusion

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.

Power Automate – How to filter SharePoint Get items results